Home > Software engineering >  For batch convert text data, to excel, the separator can be customized, and to save all of the field
For batch convert text data, to excel, the separator can be customized, and to save all of the field

Time:01-14

For batch convert text data, to excel, the separator can be customized, and to save all of the fields to text, specific requirements are as follows:
(1) I have more than one hundred tables, because in the data itself with ", ", such as "1000" this, so I cannot use the CSV commas, plans to use @ special characters such as derived from the database, so the separator to customize the
(2) the data I want to show the pure business, must be converted to Excel,
(3) is equivalent to the data table, import Excel, then respectively for the "text" (because don't want to scientific count), and then save as XLSX, same name
(4) stroll along while BBS, is basically change the suffix is given priority to, it doesn't solve my problem, need to use respectively, and a great god guidance!
  •  Tags:  
  • VBA
  • Related