Alpha Software Mobile Development Tools:   Alpha Anywhere    |   Alpha TransForm subscribe to our YouTube Channel  Follow Us on LinkedIn  Follow Us on Twitter  Follow Us on Facebook

Announcement

Collapse

The Alpha Software Forum Participation Guidelines

The Alpha Software Forum is a free forum created for Alpha Software Developer Community to ask for help, exchange ideas, and share solutions. Alpha Software strives to create an environment where all members of the community can feel safe to participate. In order to ensure the Alpha Software Forum is a place where all feel welcome, forum participants are expected to behave as follows:
  • Be professional in your conduct
  • Be kind to others
  • Be constructive when giving feedback
  • Be open to new ideas and suggestions
  • Stay on topic


Be sure all comments and threads you post are respectful. Posts that contain any of the following content will be considered a violation of your agreement as a member of the Alpha Software Forum Community and will be moderated:
  • Spam.
  • Vulgar language.
  • Quotes from private conversations without permission, including pricing and other sales related discussions.
  • Personal attacks, insults, or subtle put-downs.
  • Harassment, bullying, threatening, mocking, shaming, or deriding anyone.
  • Sexist, racist, homophobic, transphobic, ableist, or otherwise discriminatory jokes and language.
  • Sexually explicit or violent material, links, or language.
  • Pirated, hacked, or copyright-infringing material.
  • Encouraging of others to engage in the above behaviors.


If a thread or post is found to contain any of the content outlined above, a moderator may choose to take one of the following actions:
  • Remove the Post or Thread - the content is removed from the forum.
  • Place the User in Moderation - all posts and new threads must be approved by a moderator before they are posted.
  • Temporarily Ban the User - user is banned from forum for a period of time.
  • Permanently Ban the User - user is permanently banned from the forum.


Moderators may also rename posts and threads if they are too generic or do not property reflect the content.

Moderators may move threads if they have been posted in the incorrect forum.

Threads/Posts questioning specific moderator decisions or actions (such as "why was a user banned?") are not allowed and will be removed.

The owners of Alpha Software Corporation (Forum Owner) reserve the right to remove, edit, move, or close any thread for any reason; or ban any forum member without notice, reason, or explanation.

Community members are encouraged to click the "Report Post" icon in the lower left of a given post if they feel the post is in violation of the rules. This will alert the Moderators to take a look.

Alpha Software Corporation may amend the guidelines from time to time and may also vary the procedures it sets out where appropriate in a particular case. Your agreement to comply with the guidelines will be deemed agreement to any changes to it.



Bonus TIPS for Successful Posting

Try a Search First
It is highly recommended that a Search be done on your topic before posting, as many questions have been answered in prior posts. As with any search engine, the shorter the search term, the more "hits" will be returned, but the more specific the search term is, the greater the relevance of those "hits". Searching for "table" might well return every message on the board while "tablesum" would greatly restrict the number of messages returned.

When you do post
First, make sure you are posting your question in the correct forum. For example, if you post an issue regarding Desktop applications on the Mobile & Browser Applications board , not only will your question not be seen by the appropriate audience, it may also be removed or relocated.

The more detail you provide about your problem or question, the more likely someone is to understand your request and be able to help. A sample database with a minimum of records (and its support files, zipped together) will make it much easier to diagnose issues with your application. Screen shots of error messages are especially helpful.

When explaining how to reproduce your problem, please be as detailed as possible. Describe every step, click-by-click and keypress-by-keypress. Otherwise when others try to duplicate your problem, they may do something slightly different and end up with different results.

A note about attachments
You may only attach one file to each message. Attachment file size is limited to 2MB. If you need to include several files, you may do so by zipping them into a single archive.

If you forgot to attach your files to your post, please do NOT create a new thread. Instead, reply to your original message and attach the file there.

When attaching screen shots, it is best to attach an image file (.BMP, .JPG, .GIF, .PNG, etc.) or a zip file of several images, as opposed to a Word document containing the screen shots. Because Word documents are prone to viruses, many message board users will not open your Word file, therefore limiting their ability to help you.

Similarly, if you are uploading a zipped archive, you should simply create a .ZIP file and not a self-extracting .EXE as many users will not run your EXE file.
See more
See less

Export 2 Excel

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

    Export 2 Excel

    (From control panel,table and sets,double click on a table and click excel button at top)

    Seems like the Alpha Export to excel is still using the Excel 4.0 (Win 98 limitations.
    Limit of 16,350 lines.
    From excel 2000 and windows 2000 the excel limit is 65,000 lines.

    Any chance of a work around or patch so that the Alpha5v7 function would allow more that 16,000 lines???

    Charlie Crimmel

    #2
    Re: Export 2 Excel

    will be easier to copy and paste the dbf, then "import" it using excel - but there is still the record limit.
    Cole Custom Programming - Terrell, Texas
    972 524 8714
    [email protected]

    ____________________
    "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

    Comment


      #3
      Re: Export 2 Excel

      1. A5 Export to a csv with fieldnames......

      2. Excel open a dbf, save as a .xls
      Al Buchholz
      Bookwood Systems, LTD
      Weekly QReportBuilder Webinars Thursday 1 pm CST

      Occam's Razor - KISS
      Normalize till it hurts - De-normalize till it works.
      Advice offered and questions asked in the spirit of learning how to fish is better than someone giving you a fish.
      When we triage a problem it is much easier to read sample systems than to read a mind.
      "Make it as simple as possible, but not simpler."
      Albert Einstein

      http://www.iadn.com/images/media/iadn_member.png

      Comment


        #4
        Re: Export 2 Excel

        Originally posted by Al Buchholz View Post
        1. A5 Export to a csv with fieldnames......

        2. Excel open a dbf, save as a .xls
        Open excel, file menu, open, change "Files of type:" to "dBase files (*.dbf)", navigate to table, open, save as excel.

        I can also create a function to do the same if you want to automate the process.
        There can be only one.

        Comment


          #5
          Re: Export 2 Excel

          stan, can you can do it using the users excel record limit (like 65000 for 2000 thru 2003) ?

          would be nice.
          Cole Custom Programming - Terrell, Texas
          972 524 8714
          [email protected]

          ____________________
          "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

          Comment


            #6
            Re: Export 2 Excel

            Originally posted by martinwcole View Post
            stan, can you can do it using the users excel record limit (like 65000 for 2000 thru 2003) ?

            would be nice.
            I'll have to take a look at the choices available. Relying on my, hah, memory saving as excel 4.0 you specify the save as parameter as 33 as in

            xlApp.ActiveWorkbook.SaveAs(newname,33)

            resave as a .dbf

            xlApp.ActiveWorkbook.SaveAs(newname,11)

            save as an excel 2003

            xlApp.ActiveWorkbook.SaveAs(newname,-4163) 'or similar

            I'll have to play with the available choices and see how they are accepted/implemented. I suppose the function could ask what type of excel file to save as and at least try the chosen type.
            There can be only one.

            Comment


              #7
              Re: Export 2 Excel

              Stan, if its still there, I put one in there for saving and importing an excel and for exporting to excel using the old "33" or excel 4.0 version using early version 5

              haven't messed with it since. I wonder if we will be able to write to excel, in effect exporting, using the features of V8?
              Cole Custom Programming - Terrell, Texas
              972 524 8714
              [email protected]

              ____________________
              "A young man who is not liberal has no heart, but an old man who is not conservative has no mind." GB Shaw

              Comment


                #8
                Re: Export 2 Excel

                Has this problem been reported as a bug and if so has Alpha committed to fixing it? Yes there are workarounds but I think this should just work without the very small 16350 records limit.

                Comment


                  #9
                  Re: Export 2 Excel

                  Originally posted by Garry Flanigan View Post
                  Has this problem been reported as a bug and if so has Alpha committed to fixing it? Yes there are workarounds but I think this should just work without the very small 16350 records limit.
                  I don't think it is a bug. The export genie prettly clearly indicates you can export to excel version 3 or 4. The record limit is imposed by that excel version as that is as many rows as they permitted, unless I'm mistaken.

                  To export to a later version supporting more rows would likely require Alpha to purchase some sort of license.
                  There can be only one.

                  Comment


                    #10
                    Re: Export 2 Excel

                    At the risk of getting bogged down in semantics, the row limit on the export sounds more like an item for the Feature Wishlist forum than a bug.

                    Comment


                      #11
                      Re: Export 2 Excel

                      Stan,
                      You are right that it is not a bug, however to not support exporting to Excel formats other than version3 and 4 is either a serious oversight or if deliberate requires some explanation by Alpha. Excel 97 can have 65536 rows and is probably the oldest version used by most folks.

                      Comment


                        #12
                        Re: Export 2 Excel

                        Garry,

                        I see only one request in the Features Wishlist forum, from several years ago, wanting to extend the export functionality to more recent versions of Excel. Doesn't sound like the natives are clamoring for it. Perhaps the explanation for not supporting more recent versions of Excel is: (a) lack of demand in the A5 community; or (b) relatively easy work arounds, using import routines in Excel. Might just be a question of priorities, if you see what I mean. While I'm speculating here there might even be a bit of database bias at work. Some would argue that sheets with more than 16,000 rows probably belong in databases, anyway.

                        I suggest you post your idea in a new topic over in the Features Wishlist forum.

                        -- tom

                        Comment


                          #13
                          Re: Export 2 Excel

                          To assist with this problem I have built the function as follows:

                          Code:
                          FUNCTION ConvertXL AS L (SourceXLfname AS C, OutTextFname AS C, OutputType as c = "Text" )
                          ' this function converts an Excel file to desired format
                          ' SourceXLfname is the full input filename
                          ' OutTextFname is the full output filename
                          ' OutputType describes the output type
                          '    "Text" is tab separated values 
                          '    "CSV" is comma separated values with inverted comma's as text qualifiers
                          '    "DBF4" is dbase version 4
                          '    "Excel" is "Current Platform Text" whatever that means 
                          
                          dim nFileType as n
                          
                          select
                              case OutputType = "Text"
                          	    nFileType = 21
                              case OutputType = "CSV"
                          	    nFileType = 6
                              case OutputType = "DBF4"
                          	    nFileType = 11
                              case OutputType = "Excel"
                          	    nFileType = -4158
                          	case else
                          		nFileType = 0
                          end select 
                          
                          if nFileType = 0
                          	ui_msg_box("ConvertXL","Export type not recognised")
                          	ConvertXL = .f.
                          	end
                          end if
                           
                          Dim xlApp as p 
                          xlApp = ole.create("Excel.Application")
                          xlApp.Workbooks.Open(SourceXLfname) 
                          'xlApp.Visible = .T. 'comment this line out if you don't want to see Excel
                          xlapp.DisplayAlerts = .F.
                          xlApp.ActiveWorkbook.SaveAs(OutTextFname,nFileType) '33 is a constant for Excel 4.0, dbf4 is 11, tab delimited text is 21, 
                          xlApp.Workbooks.Close()
                          xlapp.DisplayAlerts = .T.
                          xlApp.Quit()
                           
                          delete xlApp
                          
                          ConvertXL = .t.
                          
                          END FUNCTION
                          If you do an export from Alpha as a text file, tab delimited, pass this function the text filename and the desired Excel filename. See sample usage as follows:

                          ?ConvertXL("c:\temp\export.txt", "c:\temp\export.xls", "Excel" )

                          This allows handling files up to 65536 rows.

                          I built this function some time ago to assist with imports, that is, converting Excel files to dbf which gets away from a lot of the type issues associated with Excel.

                          Comment


                            #14
                            Re: Export 2 Excel

                            Thanks, Garry!

                            Suggest you re-post in the Code Archive forum, since it might be of general use to others down the line. -- tom

                            Comment


                              #15
                              Re: Export 2 Excel

                              Tom,
                              I have now put ConvertXL function in the code archive with some extra comments as per your suggestion.

                              Comment

                              Working...
                              X