PASCAL viewing excel

can someone help me? To view excel file and list them using PASCAL. Thanks

Comments

  • : 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
  • : : 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
    :


    Do you mean exporting it in text format?


    --RT
  • iby can u give me sample code of uploading the CSV to PASCAL, THANKS


  • : 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:

    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




Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories