Compiling XLS files with HTML syntax is especially simple and quick. It also has basic font settings, cell merging, and other functions. It is a good way to compile reports with a style that is not very complex.
For example, the following text:
<Table> <tr> <TD> data </TD> </tr> </table>
In Excel, normal rendering is easier than using COM components. For normal reports, you do not need to use com or vsto to kill chickens.
Note that I do not know how to specify the Data Type of the cells in the report written in this way. That is to say, if a long string of numbers is to be displayed as strings, we recommend that you add & nbsp; to the front or end of a number. If you want to display a series of numbers in decimal form (that is, keep the end Of the number. 00, Excel removes the 0 at the end of the decimal point by default. Simply adding & nbsp; to it will make this cell unable to participate in the calculation in Excel, you can format the value into a 102,222.00-bit separator. This not only keeps the 0 at the end, but also applies it in Excel.
