And the text strings of the Excel cells of all worksheets per workbook are always stored in a file named " xl/sharedStrings.xml", while the worksheets are called " xl/worksheets/sheet.xml". Maybe you did not know that xlsx-files are ZIP-files. If you want to adapt our solution to your needs: edit the simple source code for the Excel.dll. net 4.5 and the standard XML-serializer of. We based our solution on the integrated ZIP-library in. This article (written by M I developer) describes all the theoretical background, if you are interested in it. Here you iterate through the worksheets, the rows (and the cells of each row) of the Excel file within three lines of code. if (cell != null) // Do something with the cells
Copy Code foreach ( var worksheet in Workbook.Worksheets( C:\ExcelFile.xlsx")
0 kommentar(er)
