All Forums  Origin Forum for Programming  LabTalk Forum  open multiple Excel Files

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize: 640 x 480 800 x 600 1024 x 768 1280 x 1024 UserName: Password: Anti-Spam Code: Format Mode: Basic  Help  Prompt  Format: Font Andale Mono Arial Arial Black Book Antiqua Century Gothic Comic Sans MS Courier New Georgia Impact Lucida Console Script MT Bold Stencil Tahoma Times New Roman Trebuchet MS Verdana   Size 1 2 3 4 5 6   Color Black Red Yellow Pink Green Orange Purple Blue Beige Brown Teal Navy Maroon LimeGreen Message: * HTML is OFF * Forum Code is ON Smilies [quote][i]Originally posted by superklee[/i] [br]Origin Version (Select Help-->About Origin): 6.1 Operating System: Windows 2000 Hi everybody, I´m trying to open a selection of multiple Excel files in Origin via labtalk. First i´v been trying to open them as origin worksheets getfilename -m *.*; // prompt for multiple files system.Excel.OpenAsExcel=0; // open as origin worksheet system.Excel.OpenAsPrompt=0; // no prompt menge = count; loop (ii, 1, menge) {getfile -g ii; doc -a %A;}; This works fine in the first loop but origin shuts itself down during the second loop. I also tried this run.section(file, Init); fdlog.usegroup(EXCEL); fdlog.multiopen(); system.Excel.OpenAsExcel=0; system.Excel.OpenAsPrompt=0; loop (ii, 1, fdlog.multiopen.count) {fdlog.get(A, ii); doc -append %A;} after reading in this forum, but I think it's pretty much the same thing and Origin also closes itself in the second loop. When I open the excel files as Excel Workbooks, everything works fine, but then i don't know how to determine the number of sheets within each workbook. Did i forget a command to kind of like reset everything, since it worked in the first loop. Or can the doc -a command not be executed twice after another? Is there maybe another way to work around it? Thanks Anita [/quote]   Check here to include your profile signature. Check here to subscribe to this topic.