A
A
Alex Rave2021-12-19 12:49:14
Programming
Alex Rave, 2021-12-19 12:49:14

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
61befb7c3cdbc328669023.png
. 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
61beff5e81d1f191694506.png
. 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

2 answer(s)
V
Vladimir Korotenko, 2021-12-19
@Rocketdock

I would use WSH
file.vb

var XLS = WScript.CreateObject("Excel.Application") ;
XLS.Workbooks.open(xlsFile) ;
var cellValue = XLS.Cells(2,2).Value ;
' тут пишите вставку в файл

cscript.exe file.vb

A
Alexander Skusnov, 2021-12-19
@AlexSku

And Excel always translates into csv.
Although, you want the INI file format.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question