Read worksheet directly from Excel file

Aspose.Cells Product Family
1

Hi,

I am using Aspose Cells for Java.
I have a 4MB Excel file which contains huge amount of data.

I need only 1 sheet data.
So I have to do the following:

Workbook wb = new Workbook(“C:\Users\sandipan.ghosh\Desktop\Test.xlsx”);
Worksheet ws = wb.getWorksheets().get(“temp”);

The new Workbook("C:… takes 12 seconds.
Cant i read the “temp” worksheet directly from the Excel file to save time?

2

@sandipanghosh111,

Thanks for your query.

I think you may load your desired worksheet(s) in the workbook, see the document for your reference:
Load Specific Worksheets in a Workbook

Please note, a worksheet can only exist in a workbook in MS Excel file format (XLS, XLSX, etc.).

Hope, this helps a bit.