Announcement

Collapse
No announcement yet.

*.xlsx Files

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • #21
    Thanks Christian, but I'm OK where I'm at. In all my production work COM works fine for me with Excel, and as a result of the feedback I've gotten through my original post and my further experiments I see that it works with xlsx too. My problem was actually a messed up Excel installation, or, maybe even more likely, a failed automatic update messed something up.
    Fred
    "fharris"+Chr$(64)+"evenlink"+Chr$(46)+"com"

    Comment


    • #22
      I have developed a program that reads xlsx files without Excel on the computer.
      If you are in fact just reading MS-Excel files, you 'technically' don't need Excel installed to read using ODBC or OLE... except the ODBC driver or OLE provider are now required. And those may require some MS-Excel components, which may require installation.

      Then again, I don't know why I'd want to deliver files in XLSX format to a user who does not have the correct software installed to read then. That is, as a "real world" scenario any real challenge is surely on the source/sender side. ("I cannot read XLSX files, please send something else").
      Michael Mattias
      Tal Systems Inc.
      Racine WI USA
      mmattias@talsystems.com
      http://www.talsystems.com

      Comment


      • #23
        I have developed a program that reads xlsx files without Excel on the computer.
        I just thought of something. Doesn't MS make available 'free for the download' a reader? They do for MS-Word. Let me do some searching ....

        ..hmmmm.... that was quick and easy ===> https://www.microsoft.com/en-us/down...ils.aspx?id=10

        Relevant quote from that page:
        Open, view, and print Excel workbooks, even if you don't have Excel installed. This download is a replacement for Excel Viewer 97 and all previous Excel Viewer versions.
        Don't feel bad. I developed this ==> CC3/Win7 Exit Code Bug Workaround October 26, 2002 .......

        ....then wouldn't you know it, PowerBASIC fixed the bug!

        Michael Mattias
        Tal Systems Inc.
        Racine WI USA
        mmattias@talsystems.com
        http://www.talsystems.com

        Comment


        • #24
          > the ODBC driver or OLE provider are now required

          Not correct. XLSX means XLS(XML spec), it is a zipped, beautifully-delimited text file that can be read by any program, regardless of drivers or a lack thereof. Word uses DOCX, and so on.
          Last edited by Eric Pearson; 28 Jul 2017, 04:58 PM.
          "Not my circus, not my monkeys."

          Comment


          • #25
            What I meant was, If you want to read MS-Excel files using ODBC or OLE, you need the ODBC driver or OLE provider, respectively.

            If your "how" is "something else, " you don't need the driver or provider.

            Michael Mattias
            Tal Systems Inc.
            Racine WI USA
            mmattias@talsystems.com
            http://www.talsystems.com

            Comment


            • #26
              Ok Michael for your reply
              ("I cannot read XLSX files, please send something else").

              I can read multiple xlsx files with Libre Office.

              But to cumulate xlsx files, I have not seen a simpler solution than reading them with Powerbasic, then cumulating the data on each tab and finally rewriting the cumulative file that contains the cumulative tabs of all files.

              For her work my daughter asked me to develop a program that cumulates each tab of a large series of files, to finally render a single file with in each tab is cumulation of tabs of all files.

              A compiled programm allows him to do this work every month in a few minutes to follow the advancement of hundreds of projects of a group of clinics (144 units).

              Comment

              Working...
              X