Loading

"excel to table" - how to change code to open 2nd and next sheets

Peter Prince

5y811

I have implemented the code in "Reading An Excel File Using HTML 5 And jQuery" (excel to table) - and it really works great!

Can someone suggest the changes in the code to be able to access not only first sheet, but the n-th one?

Thank you in advance

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Salman Beg5y ago
Accepted answer
Can you please check this link which explain the same what you are looking for, https://www.c-sharpcorner.com/article/reading-a-excel-file-using-html5-jquery/ https://www.aspsnippets.com/Articles/Read-Parse-Excel-File-XLS-and-XLSX-using-jQuery.aspx
+1
Peter Prince5y ago
https://www.aspsnippets.com/Articles/Read-Parse-Excel-File-XLS-and-XLSX-using-jQuery.aspx has the answer!

Code for the second sheet:

...

...

//Fetch the name of Second Sheet.

var secondSheet = workbook.SheetNames[1];

//Read all rows from Second Sheet into an JSON array.

var excelRows = XLSX.utils.sheet_to_row_object_array(workbook.Sheets[secondSheet]);

...

...

Thanks Salman!
0