HTML Style not working when Convert HTML file to Excel file by using Aspose.Cells

dluo · February 23, 2016, 7:58pm

When Convert HTML content into Excel file by Aspose Cells:

The table style in HTML file is not working. Background color & Vertical-align & table border etc.
The Image file in html file also is not working.

Where can I find the detail document for Converting HTML to excel? I only found http://www.aspose.com/docs/display/cellsnet/Converting+HTML+files+to+Excel+Spreadsheets

Thanks!

shakeel.faiz · February 23, 2016, 9:26pm

Hi,

Thanks for your posting and using Aspose.Cells.

Please share your HTML file which you are converting to Excel file. We will look into it if your HTML file is convertible or not. Please note, not all types of HTML can be converted to Excel file. Only Excel-Oriented HTML files can be converted to Excel file.

dluo · February 25, 2016, 1:15pm

Please review the attached html file. Thanks!

babar.raza · February 25, 2016, 11:43pm

Hi Douglas,

Thank you for sharing the sample HTML.

We have evaluated the presented scenario while using the latest revision of Aspose.Cells for .NET 8.7.1, and we are able to notice the problem as mentioned in point 1) of your original post, that is; formatting is getting lost while converting the HTML to spreadsheet format (we have tested by storing the result in XLSX file format). We have logged this incident as CELLSNET-44263 in our bug tracking system for further investigation and we require some time for proper analysis. Regarding point 2) from your original post, you haven’t shared the image that is being referenced in the HTML therefore we are not able to evaluate this case. Moreover, when we tried to convert the HTML with Excel application, the image is not being displayed in Excel generated XLSX as well. Please review the resultant spreadsheets in attachment.

dluo · February 26, 2016, 11:48am

I reviewed your attached 2 files. The “Excel-Saved.xlsx” is much better than “Aspose-Saved.xlsx”.

In “Excel-Saved.xlsx”, only the content is different with the html file in browser. If the content is vertical align middle, the export will be perfect.

But in Aspose-Save.xlsx", there are the following issues:

1. The title should be multiple lines (current 2 lines)

2. Table header color and background color is lost.

3. Table content is not vertical align middle.

4. Table column width issue, and the date content can’t be shown up.

5. The link in the table doesn’t work.

6. The company logo is not shown up. Our company logo is a jpg file (127*49)

Thanks,

Douglas

babar.raza · February 27, 2016, 1:52pm

Hi Douglas,

Thank you for the detailed analysis.

I have logged your comments to the aforementioned ticket and have requested the concerned member of the product team to consider these points while investigating the matter. Regarding the point 6) as discussed earlier, the image isn’t visible in HTML either (due to the broken link as image is not available at specified location) therefore it will not be displayed in the resultant spreadsheet as well. It would be appropriate that you should share the image (Company_logo.jpg) so we could test this case with your sample entirely.

dluo · April 20, 2016, 11:24am

long time ago, I sent the sample image to your guys by email. What is the status right now?

babar.raza · April 20, 2016, 11:41am

Hi Douglas,

Thank you for writing back.

I am afraid, the ticket logged earlier as CELLSNET-44263 is currently unresolved. We have requested the concerned member of the product team to share the current status, and preferably an ETA for the fix. As soon as we get any news, we will post here for your kind reference.

Regarding the sample image, could you please state where and how you sent the image?

babar.raza · April 25, 2016, 12:53am

Hi again,

This is to update you that we will try our best to provide the fix for the ticket logged earlier as CELLSNET-44263 during the second week of May 2016. Thank you for your patience with us.

shakeel.faiz · May 11, 2016, 5:10am

Hi,

Thanks for using Aspose.Cells.

Please download and try the latest fix: Aspose.Cells for .NET (Latest Version).

About CELLSNET-44263, there are some information for you:

1. About the details of the problem. We have fixed 1, 2, 4, 5 and 6.

Details of the problem
1. The title should be multiple lines (current 2 lines)
2. Table header color and background color is lost.
3. Table content is not vertical align middle.
4. Table column width issue and the date content can’t be shown up.
5. The link in the table doesn’t work.
6. Font size is changed

About table content is not vertical align middle. It is same as MS-Excel for now. It is complicated, we will fix it later.

2. Please use the following code:

C#

Workbook wb = new Workbook(“listingreport.html”);
wb.Worksheets[0].AutoFitRows();
wb.Worksheets[0].AutoFitColumns();
wb.Save(“out.xlsx”);

aspose.notifier · May 24, 2016, 3:33am

The issues you have found earlier (filed as CELLSNET-44263) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

babar.raza · May 30, 2016, 3:19am

Hi Douglas,

Please try the latest version of Aspose.Cells for .NET (Latest Version) for the remaining issues of the ticket CELLSNET-44263. Please let us know your feedback so we could close the aforementioned ticket.

jli · May 30, 2016, 5:43pm

Hi,

I have tried with 8.8.1.2.

A) I have found two problems:

Cannot show the images correctly after export html to excel.
Cannot export all html content to excel,especially when the html has nested elements.

B) Here is the code I used to test:

private void button1_Click(object sender, EventArgs e)

{

var export_html = @"

7/21-2 full

Admin_O_F Admin_O_L

abc@abc.com

1234567890

ABC DEF

Generated OnMay 30, 2016 02:33 PM 
Time Call Received from Jan 01, 2016 to May 30, 2016

";

using (MemoryStream ms = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(export_html)))

{

Aspose.Cells.LoadOptions loadOptions = new Aspose.Cells.LoadOptions(Aspose.Cells.LoadFormat.Html);

//use the stream here and don’t worry about needing to close it

Workbook wb = new Workbook(ms, loadOptions);

wb.Worksheets[0].AutoFitRows();

wb.Worksheets[0].AutoFitColumns();

var worksheet = wb.Worksheets[0]; 

wb.Save(“c:\test2.xlsx”, Aspose.Cells.SaveFormat.Xlsx);

}

}

C) The attached files :

Screenshot of the results, expected results VS actually results.
The image used for testing.

Looking forward to hearing from you

Thanks

Jeff

babar.raza · May 31, 2016, 2:45am

Hi Jeff,

Thank you for sharing your feedback. We have evaluated the recently shared scenario against the latest revision of Aspose.Cells for .NET 8.8.1.2 and we are able to replicate both issues. In order to further investigate the matter, we have logged 2 tickets against the mentioned issues. Please find the below details for your future reference.

CELLSNET-44466: Cannot show the images correctly after export HTML to spreadsheet
CELLSNET-44467: Cannot export all HTML content to spreadsheet when the HTML has nested elements

Please spare us little time to properly investigate the aforementioned issues and get back to you with updates in this regard.

shakeel.faiz · May 31, 2016, 4:32am

Hi,

Thanks for your using Aspose.Cells.

For your issue logged as CELLSNET-44466, please download and try the latest fix: Aspose.Cells for .NET (Latest Version) and let us know your feedback.

We have fixed the issue of importing image from Html file to Excel.

aspose.notifier · June 3, 2016, 4:13am

The issues you have found earlier (filed as CELLSNET-44466;CELLSNET-44263) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.

shakeel.faiz · June 7, 2016, 3:16am

Hi,

Thanks for using Aspose.Cells.

It is to inform you that we have fixed your issue CELLSNET-44467 now. We will soon provide the fix after performing QA and including other enhancements and fixes.

shakeel.faiz · June 14, 2016, 1:37am

Hi,

Thanks for your using Aspose.Cells.

We have fixed the issue CELLSNET-44467 .

Please download and try the latest fix:
Aspose.Cells for .NET (Latest Version) and let us know your feedback.

About CELLSNET-44467 , there are some tips for you.

The fix adds HTMLLoadOptions.SupportDivTag property

Indicates whether to support the layout of

tag when the html file contains

tags. The default value is false.

The sample code is as follow:

C#

var export_html = @"

7/21-2 full

Admin_O_F Admin_O_L

[abc@abc.com](mailto:abc@abc.com)

1234567890

ABC DEF

Generated OnMay 30, 2016 02:33 PM 
Time Call Received from Jan 01, 2016 to May 30, 2016

";

using (MemoryStream ms = new MemoryStream(System.Text.Encoding.UTF8.GetBytes(export_html)))
{

Aspose.Cells.HTMLLoadOptions loadOptions = new HTMLLoadOptions(LoadFormat.Html);

loadOptions.SupportDivTag = true;

//use the stream here and don’t worry about needing to close it

Workbook wb = new Workbook(ms, loadOptions);

wb.Worksheets[0].AutoFitRows();

wb.Worksheets[0].AutoFitColumns();

var worksheet = wb.Worksheets[0];

wb.Save(filePath + “source.xlsx”, Aspose.Cells.SaveFormat.Xlsx);
}

aspose.notifier · June 28, 2016, 5:47am

The issues you have found earlier (filed as CELLSNET-44467) have been fixed in this update.

This message was posted using Notification2Forum from Downloads module by Aspose Notifier.