: can someone help me? To view excel file and list them using PASCAL. Thanks :
Try exporting excel file into CSV (comma separated values) and rest is then easy. The cells content is saved in plain text and delimiter is character you choose (usually comma).
: : can someone help me? To view excel file and list them using PASCAL. Thanks : : : : Try exporting excel file into CSV (comma separated values) : and rest is then easy. The cells content is saved in plain : text and delimiter is character you choose (usually comma). : : Iby :
: iby can u give me sample code of uploading the CSV to PASCAL, THANKS : :
No but I can help you troubleshoot your code. The idea behind this forum is not to give you ready code but to help you in case you get stuck with your own program. Give it a try. CSV is just a text file. Just create new excel sheet, type something into couple cells and save as CSV and then open the CSV in Notepad. It should look like:
You could create a two dimensional array to match the cell arangement. Depending on the cell content you will have to declare proper type of the array.
Use any way to read the CSV into array. Since CSV is just a text file, you could check the pascal help for TEXT. There is a sample code how to treat the text file.
Comments
:
Try exporting excel file into CSV (comma separated values)
and rest is then easy. The cells content is saved in plain
text and delimiter is character you choose (usually comma).
Iby
: :
:
: Try exporting excel file into CSV (comma separated values)
: and rest is then easy. The cells content is saved in plain
: text and delimiter is character you choose (usually comma).
:
: Iby
:
Do you mean exporting it in text format?
--RT
:
:
No but I can help you troubleshoot your code.
The idea behind this forum is not to give you
ready code but to help you in case you get stuck
with your own program. Give it a try.
CSV is just a text file. Just create new excel sheet,
type something into couple cells and save as CSV
and then open the CSV in Notepad.
It should look like:
cell-11,cell-12,cell-13,...
cell-21,cell-22,cell-23,...
cell-31,cell-32,cell-33,...
You could create a two dimensional array to match the
cell arangement. Depending on the cell content you
will have to declare proper type of the array.
Use any way to read the CSV into array. Since CSV
is just a text file, you could check the pascal help
for TEXT. There is a sample code how to treat the
text file.
I hope this helps (at least for now).
Iby