Apkawa/xlsx2html

Generates limited HTML, limited to only single sheet of Excel.

ShahzaibAhmedKhan31 opened this issue · 0 comments

Issue:
Currently, when using the xlsx2html Python library to convert xlsx files to HTML, the generated HTML output is limited to only the first sheet in the xlsx file. This limitation prevents users from obtaining HTML representations for all sheets present in their xlsx files, which is a crucial feature for many use cases.

Expected Behavior:
The xlsx2html library should generate HTML output for all sheets in the xlsx file, allowing users to accurately convert their xlsx data into HTML format.

Steps to Reproduce:

Use the xlsx2html library to convert an xlsx file with multiple sheets to HTML.
Verify that the generated HTML output only contains data from the first sheet.

Proposed Solution:
The issue can be addressed by modifying the library's code to iterate over all sheets in the xlsx file and generate HTML output for each sheet accordingly. This modification will ensure that users can obtain HTML representations for all sheets present in their xlsx files.

I have already resolved this on my side. Following is the change that I have did:

Fix

I have updated sheet_list with wb.sheetname as you can see in above image. It resolved my problem.

Additional Information:

Library version: 0.5.0
Python version: 3.11.4
Operating system: Windows 10 / Linux