Answer the question
In order to leave comments, you need to log in
How to parse a table and write to a file?
Kind time of the day
The task is to get a text file from an excel file.
The content of the table is as follows
. This table cannot be changed in any way, it is formed by the automation of the cinema.
From this table, the fields "HALL" and "INFORMER'S TIME" are required.
The fields must be entered in a text file with this content
. In yellow, it is necessary to put the fields from the table.
And now the actual question is how to do all this using standard Windows tools?
Answer the question
In order to leave comments, you need to log in
I would use WSH
file.vb
var XLS = WScript.CreateObject("Excel.Application") ;
XLS.Workbooks.open(xlsFile) ;
var cellValue = XLS.Cells(2,2).Value ;
' тут пишите вставку в файл
And Excel always translates into csv.
Although, you want the INI file format.
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question