Howdy, Stranger!

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

Categories

PASCAL viewing excel

RTCHRONORTCHRONO Member Posts: 3
can someone help me? To view excel file and list them using PASCAL. Thanks

Comments

  • ibyiby Member Posts: 323
    : 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
  • RTCHRONORTCHRONO Member Posts: 3
    : : 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
  • RTCHRONORTCHRONO Member Posts: 3
    iby can u give me sample code of uploading the CSV to PASCAL, THANKS


  • ibyiby Member Posts: 323
    : 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




  • Chris BrownChris Brown USAMember Posts: 4,496 ✭✭

    __ // http://forcoder.org // free ebooks and video tutorials about \ Visual Basic .NET, C++, R, MATLAB, JavaScript, Swift, Go, C, PHP, Perl, Visual Basic, Ruby, PL/SQL, Delphi, Assembly, Python, Scratch, Java, Objective-C, C# Logo, Fortran, COBOL, Crystal, Prolog, Alice, Scala, Bash, Lisp, D, Kotlin, Transact-SQL, Ada, Dart, Erlang, LabVIEW, FoxPro, ABAP, F#, ML, Apex, Rust, Julia, Hack, Clojure, Awk, SAS, Lua, Scheme, VBScript \ ____

Sign In or Register to comment.