How to read .xls specific cell data using GemBox in c#

Question

Please help me to fetch or to read specific cell data of .xls spreed sheet using GemBox in c#.

I am able to write but fails to read the specific cell data.

I don't want to read all data at once.

var dataSet = new DataSet();
        SpreadsheetInfo.SetLicense("FREE-LIMITED-KEY");
        GemBox.Spreadsheet.ExcelFile ef = new GemBox.Spreadsheet.ExcelFile();
       // ExcelFile ef = ExcelFile.Load(@"C:\Users\LENOVO\Documents\100sitesSpreedSheet.xls");
        ef = GemBox.Spreadsheet.ExcelFile.Load(@"C:\Users\LENOVO\Documents\100sitesSpreedSheet.xls");
        ExcelWorksheet ws = ef.Worksheets["100sitesSpreadSheet"];
        ws.Cells[6, 0].Value = "abcd";
        ef.Save(@"C:\Users\LENOVO\Documents\100sitesSpreedSheet.xls");

Show your work and tell us what have you tried and where you stuck. — Soner Gönül, May 01 '14 at 15:52
Updated your code in your question with `edit` button under your question. — Soner Gönül, May 01 '14 at 15:57
M sorry my code may look hapazard, but I am not able to post it in synchronised manner.. The above code writes data to specific cell, but how to read data from same specific cell or from other cell — Vivek Sharma, May 01 '14 at 15:59
I think I got the way, I simply tried.. `Console.WriteLine((ws.Cells["A7"].GetFormattedValue()));` — Vivek Sharma, May 01 '14 at 16:44

score 0 · Answer 1 · answered May 05 '14 at 09:02

to read the specific cell's value you can just use the Value property, like the following:

Console.WriteLine(ws.Cells["A7"].Value);

This property is of an object type and can return a text or a number or a date, depending on the data it stores. Also note that GetFormattedValue method actually converts that value into a string representation by using a number format which is applied to that cell.

How to read .xls specific cell data using GemBox in c#

1 Answers1