I need to allow a user to interactively choose the spreadsheet to open but then provide a list, dropdown, etc. for the user to then choose the worksheet(s) to import.

I haven't been able to find anything in the documentation that addresses how to get a list of the worksheets in a workbook and would appreciate any information or direction where I might be able to find this.

Thanks,

You ca use the following methods to build the list of worksheets:
ExcelDocument.SheetCount
ExcelDocument.easy_getSheetAt

Hi Daniela,

While your solutiopn will tell me the number of sheets in the workbook and then allow importing them via the ordinal number it doesn't address my need of getting a list of the sheet names to then present to a customer from which they can the choose the sheet that they want to import.

I've found a method that works in C#, basically opening the workbook with OLEDB and then getting all the "tables" from the schema.

Since I've purchased the EasyXLS library and it is all about reading and writing workbooks and formatted worksheets, I assume that this would be one of the basic functionalities that EasyXLS would provide.

You can use a code similar with this:

//Create the sheet list for the dropdown
ExcelDocument xls = new ExcelDocument();
xls.easy_LoadXLSFile(file);
for (int nSheet=0; nSheet<xls.SheetCount(); nSheet++){
yourlist.add(xls.easy_getSheetAt(nSheet)).getSheetName();
}

......................................................

//Load the selected sheet for the dropdown list
ExcelWorksheet xlsWorksheet = (ExcelWorksheet)xls.easy_getSheet(selectedSheetName);

Hi Daniela,

Thanks for the response but please see my previous comments regarding using only the EasyXLS functionallity.

Both of your previous suggested solutions would require Excel or at least the Excel runtime to be installed on our server... which our administrators refuse to do.

I need a EasyXLS based solution.

If EasyXLS doesn't support this then please just say so and I can get on with business.

Thanks,

Gregg

Microsoft Excel is not required to be installed.