Free Support Forum - aspose.com

Reading from hidden worksheets in Excel

Hi, does anyone know whether it is possible to read cell contents from a hidden worksheet in an Excel Workbook? I am a new user of Apose.Excel so don’t have much knowledge of the application. The architecture we are using is to read from an excel file and write the contents of the file to another application using a xml mapping file. Thanks for your help in advance.

Hi,

Aspose.Excel can read hidden worksheets from desginer file.

Hi Laurence, thanks for that. As I am a new user of Apose.Excel I’m not quite sure what you mean when you say it can read hiiden worksheets from designer file. Please can you give me a bit more detail. Regards.

For example,

You create a designer file with 3 sheets. In cell A1 of sheet1, you input string “hello,world”. Then you hide sheet1 and save it.

Now you can try the following code:

private void Page_Load(object sender, System.EventArgs e)
{
Excel excel = new Excel();
excel.Open(“d:\book1.xls”);
Response.Write(excel.Worksheets[0].Cells[“A1”].StringValue);
}


Aspose.Excel allows you to read data in a hidden sheet.