Modification of xls file
-
I have created an excel file via code . I want to write data in the file for that I want to increase the size of cells via program and write some text bold format as per my requirement. How to do this?
-
I have created an excel file via code . I want to write data in the file for that I want to increase the size of cells via program and write some text bold format as per my requirement. How to do this?
You can use Excel Automation (COM / OLE Dispatch) which requires an installed Excel (for examples see How to automate Excel from C++ without using MFC or #import[^], Automating Excel 2007 and creating charts using C++ MFC application in Visual Studio 2008[^], and MS Office OLE Automation Using C++[^]). If Excel is not present on the target machine you can use a library that supports the required operations (e.g. ExcelFormat Library[^] or commercial products like LibXL).
-
I have created an excel file via code . I want to write data in the file for that I want to increase the size of cells via program and write some text bold format as per my requirement. How to do this?