using System;

​

using System.Collections.Generic;

​

using System.Linq;

​

using System.Text;

​

using System.Threading.Tasks;

​

using Microsoft.Office.Interop.Excel;

​

using Excel = Microsoft.Office.Interop.Excel;

​

using System.IO;

​

namespace Reader

​

{

​

class Program

​

{

​

static void Main(string[] args)

​

{

​

Console.WriteLine("Please Copy Folder and paste it here ");

​

var dirPath = @"" + Console.ReadLine();

​

Console.WriteLine("Please Create output txt file and pate its path here: \n example ((c:/output.txt))");

​

var outPath = @"" + Console.ReadLine();

​

var filesss = Directory.GetFiles(dirPath);

​

Console.WriteLine("How many Cells you need to fetch: ");

​

var noOfCells = int.Parse(Console.ReadLine());

​

List<Cell> cellvalues = new List<Cell>(noOfCells);

​

Console.WriteLine("Please Enter Cell name , Cell Row ,Cell Column ((Comma Separated))");

​

for (int i = 0; i < noOfCells; i++)

​

{

​

var read = Console.ReadLine();

​

var cellname = read.Split(',')[0];

​

var cellrow = read.Split(',')[1];

​

var cellcolumn = read.Split(',')[2];

​

cellvalues.Add(new Cell(Convert.ToInt32(cellrow), Convert.ToInt32(cellcolumn), cellname));

​

}

​

for (int i = 0; i < filesss.Length; i++)

​

{

​

var excelfile = new ExcelReader(filesss[i], 1);

​

List<string> res = new List<string>();

​

for (int j = 0; j < noOfCells; j++)

​

{

​

res.Add(excelfile.ReadCell(cellvalues[j].row, cellvalues[j].col));

​

}

​

string[] thearray = res.Select(h => h.ToString()).ToArray();

​

var result = string.Join(",", thearray);

​

File.AppendAllText(outPath, result + Environment.NewLine);

​

excelfile.close();

​

}

​

Console.WriteLine("Done");

​

Console.ReadLine();

​

}

​

public class Cell

​

{

​

public int row=1;

​

public int col=1;

​

public string cellName="";

​

public Cell(int x, int y, string z)

​

{

​

row = x;

​

col = y;

​

cellName = z;

​

}

​

}

​

class ExcelReader

​

{

​

string path = "";

​

_Application excel = new Excel.Application();

​

public Workbook wb;

​

public Worksheet ws;

​

object misvalue = System.Reflection.Missing.Value;

​

public ExcelReader(string path, int sheet)

​

{

​

this.path = path;

​

wb = excel.Workbooks.Open(path);

​

ws = wb.Worksheets[sheet];

​

}

​

public string ReadCell(int i, int j)

​

{

​

return ws.Cells[i, j].Value2.ToString();

​

}

​

public void close()

​

{

​

wb.Close(false, misvalue, misvalue);

​

excel.Quit();

​

System.Runtime.InteropServices.Marshal.FinalReleaseComObject(excel);

​

}

​

}

​

}

​

}