Hello, everyone. I want to know if I have an excel table and want to set the cell border. I can't find it online for a long time. Now we can find the method to set the cell value: $ workbook & nbsp; D: a.xls; & nbsp; start Excel & nbsp; $ ms_excelnew & nbsp; COM (excel. application) & nb php com component excel
Hello everyone, I want to ask, I have an excel table. I want to set the cell border. I can't find it online for a long time.
The method for setting the cell value is found:
$ Workbook = "D: \ a.xls ";
// Start Excel
$ Ms_excel = new COM ("excel. application") or die ("Excel application cannot be opened ");
$ Ms_excel-> WorkSheets ('sheet1')-> Range ('A1')-> Value = "SN ";
If you want
How can I set the cell A1 with a border? thank you ~
------ Solution --------------------
1. if your excel file is fully installed, you will have a complete help manual in the tool -- macro -- Microsoft script editor.
But unfortunately, most of the current use of the simplified version of excel, he needs to install the CD
2. since you cannot get help from excel, you can know the usage from phpexcel. Phpexcel fully simulates vba operations
Therefore, code written in phpexcel can be used for com applications.
------ Solution --------------------
PHP Excel is a good solution.
Http://www.cnblogs.com/icgg/articles/1647064.html
