In VB to realize the function of an export Excel, but there is no office computer, WPS, how do I implement this function, VB how to interact with the WPS

CodePudding user response:

Comma segmentation data, save the file name extension CSV.

CodePudding user response:

Can be directly output text file
1, CSV
2, the XML as the carrier to save as XLSX file (search for specific specification, should support from O13)

CodePudding user response:

1. The simplest, with the CSV file, but some similar Numbers of text information, such as serial number 0001 May show less right
2. According to the WPS official claims that the WPS and excel the same API interface, so it should be used as the Set oExcel=CreateObject (" et. Application ") statements to manipulate, but not exactly the same, really I didn't try not sure
3. Use MS OpenXML API

CodePudding user response:

You can try the CSV

CodePudding user response:

Use an empty EXCEL file,
To export, a copy of it,
Then, in the form of database open, insert the data,

CodePudding user response:

Each column of data with the TAB TAB, so that we can make the elements more rich, such as color, font, digital prevent scientific notation, and so on, to save the suffix directly. XLS can, much better than the CSV