I.T. Discussion Community!
Jeff Rumage -Collapse +Expand
-Collapse +Expand
Jeff.R3
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (54)

Search Jeff.R3:

Advanced
Business Account . . .
rum
KY USA
Rank: Cadet 4th Year




Represented here by . . . 
Real Name:  Jeff Rumage
Primary Role:  ---
Joined: Jun 2017 (11 months ago)
Visits: 47
Member Points82
Member pending approval.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Highlights

Posted within the last 90 days.
More...
New?   Title Created By For...
New Stuff Since Your Last Visit 1. RE: Export table to spreadsheet
Another approach is a free 3rd party (ancient) tool called Sportamok's Paradox dBase Reader (v2.2.0). When I'm sharing database files with non-Paradox users, that's what I suggest.
Posted to MB Topic: ObjectPAL  « Paradox Board
145 minutes ago

dcheney
   2. RE: Export table to spreadsheet...again! By Steven.G
New Stuff Since Your Last Visit 3. RE: Search multiple Scripts
Hey David,   I dont know if you found a solution to your issue.  Let me tell you how I do that. As  Steven suggested, I use enumsourcetofile,  (and it does work on script files).   For each object I script i create a .src file. For instance if I compile   test.ssl,  I use enumsourcetofile to send the script to test.ssl.src All of the src files are stored in the same folder. When I need to search for something, I open Notepad++  and use the "Find in Files" function and I filter on the .SRC files Hope this helps.
Posted to MB Topic: ObjectPAL  « Paradox Board
61 hours ago

Jeff.R3
New Stuff Since Your Last Visit 4. RE: Export table to spreadsheet
I resolved this issue.   I no longer have version issues in excel.cool In the end I wrote a parser to create an xml representation of the data,  then ask excel to open it. The export process is super fast and it gives me the ability to add headers, create freeze panes, and bold face text. all the developer has to do is call the function with the following arguments
  • TName string ;  Table name to export
  • SSName String; Spreadsheet name to save as
  • bShowHeader Logical;  Yes/No to show header info in first four rows
  • strCompany String; client name
  • strHeader String ; report name
  • strAsOfDate String ; As of date for the data in the file
  • strPrintDate String; print date of the data (creation date)
  • OpenExcel Logical ;  Display in excel when complete
  • Posted to MB Topic: ObjectPAL  « Paradox Board
    61 hours ago

    Jeff.R3
       5. Export table to spreadsheet...again! By Jeff.R3
    More...

    Updated 90 Day Posts: All Types

    Updated within last 90 days and not in the new 90 day posts list above.
    New?   Title Created By For...
    New Stuff Since Your Last Visit 1. RE: Export table to spreadsheet
    Another approach is a free 3rd party (ancient) tool called Sportamok's Paradox dBase Reader (v2.2.0). When I'm sharing database files with non-Paradox users, that's what I suggest.
    Posted to MB Topic: ObjectPAL  « Paradox Board
    145 minutes ago

    dcheney
       2. RE: Export table to spreadsheet...again! By Steven.G
    New Stuff Since Your Last Visit 3. RE: Search multiple Scripts
    Hey David,   I dont know if you found a solution to your issue.  Let me tell you how I do that. As  Steven suggested, I use enumsourcetofile,  (and it does work on script files).   For each object I script i create a .src file. For instance if I compile   test.ssl,  I use enumsourcetofile to send the script to test.ssl.src All of the src files are stored in the same folder. When I need to search for something, I open Notepad++  and use the "Find in Files" function and I filter on the .SRC files Hope this helps.
    Posted to MB Topic: ObjectPAL  « Paradox Board
    61 hours ago

    Jeff.R3
    New Stuff Since Your Last Visit 4. RE: Export table to spreadsheet
    I resolved this issue.   I no longer have version issues in excel.cool In the end I wrote a parser to create an xml representation of the data,  then ask excel to open it. The export process is super fast and it gives me the ability to add headers, create freeze panes, and bold face text. all the developer has to do is call the function with the following arguments
  • TName string ;  Table name to export
  • SSName String; Spreadsheet name to save as
  • bShowHeader Logical;  Yes/No to show header info in first four rows
  • strCompany String; client name
  • strHeader String ; report name
  • strAsOfDate String ; As of date for the data in the file
  • strPrintDate String; print date of the data (creation date)
  • OpenExcel Logical ;  Display in excel when complete
  • Posted to MB Topic: ObjectPAL  « Paradox Board
    61 hours ago

    Jeff.R3
       5. Export table to spreadsheet...again! By Jeff.R3

    Message Boards Activity

    54 posts.
    More...

    Thread 6 of 6
    Thread Starter or a Reply (but not last)  Group

    rum
    Export table to spreadsheet
    exportSpreadsheet Does anyone know of an alternative method to export data from a table to a spreadsheet? I am currently using this,   exportSpreadsheet ( const tableName String, const fileName String [ , const makeRowHeaders Logical ] ) Logical but it has some extreme limitations,  such as FONT control and the number of lines you can export.
    Posted to MB Topic: ObjectPAL « Paradox Board
    5 days ago

    dcheney
    Another approach is a free 3rd party (ancient) tool called Sportamok's Paradox dBase Reader (v2.2.0). When I'm sharing database files with non-Paradox users, that's what I suggest.
    143 minutes ago
    New Stuff Since Your Last Visit
    48
    Hits

    Corel Paradox / ObjectPAL Coding

    Thread 5 of 6
    Thread Starter or a Reply (but not last)  Group

    rum
    RE: Search multiple Scripts
    Hey David,   I dont know if you found a solution to your issue.  Let me tell you how I do that. As  Steven suggested, I use enumsourcetofile,  (and it does work on script files).   For each object I script i create a .src file. For instance if I compile   test.ssl,  I use enumsourcetofile to send the script to test.ssl.src All of the src files are stored in the same folder. When I need to search for something, I open Notepad++  and use the "Find in Files" function and I filter on the .SRC files Hope this helps.
    Posted to MB Topic: ObjectPAL « Paradox Board
    61 hours ago
    New Stuff Since Your Last Visit
    Corel Paradox / ObjectPAL Coding

    Thread 4 of 6
    Thread Starter or a Reply (but not last)  Group

    rum
    RE: Export table to spreadsheet
    I resolved this issue.   I no longer have version issues in excel.cool In the end I wrote a parser to create an xml representation of the data,  then ask excel to open it. The export process is super fast and it gives me the ability to add headers, create freeze panes, and bold face text. all the developer has to do is call the function with the following arguments
  • TName string ;  Table name to export
  • SSName String; Spreadsheet name to save as
  • bShowHeader Logical;  Yes/No to show header info in first four rows
  • strCompany String; client name
  • strHeader String ; report name
  • strAsOfDate String ; As of date for the data in the file
  • strPrintDate String; print date of the data (creation date)
  • OpenExcel Logical ;  Display in excel when complete
  • Posted to MB Topic: ObjectPAL « Paradox Board
    61 hours ago
    New Stuff Since Your Last Visit
    Corel Paradox / ObjectPAL Coding
    More...
    -
       Contact Us!
     
    PrestwoodBoards.com was developed and is maintainted by me. Do you have a question or suggestion? Do you see a problem? Contact me now. My goal is to build an ad-free and spam-free source of I.T. information with many contributers (ok to promote your website/company in your bio). Yes, my company Prestwood IT Solutions is mentioned in my bio which shows with every post, but you can contribute and promote your pet project too!

    1,999 People Online Now!!  
    Sign In to see who's online now!  Not a member? Join now. It's free!
    Show more stats...


    ©1995-2018 PrestwoodBoards  [Security & Privacy]
    Professional IT Services: Coding | Websites | Computer Tech