Fei-Sheng-Wu/XlsxToHtmlConverter

Cannot Convert -> Object Reference not set

Jijaxxx opened this issue · 5 comments

Hi Team,
Thanks for the job that you are doing, I am having a issue when I tried to convert mu Excel to Html
on line 488
if (config.IsConvertHiddenSheet == false && currentSheet.State.Value != SheetStateValues.Visible)
-> Throw an Object Reference not set. Indeed, the currentSheet.State is null.

If I comment this instruction. Nothing is happening. Getting a timeout.
Thanks for your help.
JJ

@Jijaxxx

Thanks for using,

We will add your issue into our BUG list, it will be resolved within 3-5 days. Please wait patiently.

Also, can you send your Excel file to us? We may need your file to test.

rdoa.xlsx
Hi @Fei-Sheng-Wu , Many thanks for you answer.
please find attached the file that I tried to convert.
Many thanks

@Jijaxxx

Hi,

Good news, we solved the bug you found. The files you submit can be converted successfully.

Checkout the newest update (version 1.1.12) on Github or Nuget now!

This is what the conversion result looks like when we tested it:

output-html-thumbnail-browser

Full window:

output-html-thumbnail-full.jpg

@Jijaxxx

Also, we noticed you are using some text boxes in your excel file:

screen-snip-excel-file-text-box

Currently, we are not support textbox. These text box are not as same as the texts in the cells, they are on top of cells and overlap them.

But it is also a task in our features list and has a higher priority, it may be supported in next release.

For now, you can just put these text into cells but not create a text box. We can convert cells data into html correctly.

If you still have any questions about text box, please create a new issue. I will close this issue for now.

Look Great man. Many thanks.
It works now.