Related issues of Excel to html conversion

叶孤城

When converting to HTML, I encountered such a problem that the number in Excel became #### because the grid was too short, and it was not converted when converting to HTML. It was also #####. How to solve this problem La?

苹果小刀

Try to set the cell properties of Excel!

shenmue024

When generating html.

<TD sytle = 'mso-number-format:\@'> Content </ td>

当头一棒

Would n’t it be nice to set the width of the Excel cell wide?

shenmue024

Is it using excel object to convert html?

Set the format of td to text. Add a 'in front

weh007

mark

叶孤城

<TD sytle = 'mso-number-format:\@'> Content </ td>
=============================================
I will directly call the Saveas method without HTML manipulation


Try to set the cell properties of Excel!
==========================
Because it is uploaded as an attachment, how to design the cell attributes

Would n’t it be nice to set the width of the Excel cell wide?
================================================== =========
When the amount of Excel data is large, users cannot set their widths one by one

shenmue024

// Assume that the second column needs to be widened.
Just find a cell in the second column.

Excel.ApplicationClass el = new Excel.ApplicationClass ();
object o = Type.Missing;
Excel.Workbook book = el.Workbooks.Open ("d:\\aa.xls", o, o, o, o, o, o, o, o, o, o, o, o,
o, o, o, o);
Excel.Worksheet sheet = (Excel.Worksheet) book.Worksheets [1];
The
((Excel.Range) sheet.Cells [1,2]). ColumnWidth = 30;
The
book.SaveAs ("d:\\bb.html", Excel.XlFileFormat.xlHtml, o, o, o, o, Excel.XlSaveAsAccessMode.xlExclusive, o, o, o, o, o);
The
el.Quit ();