The Origin Forum
File Exchange
Try Origin for Free
The Origin Forum
Home | Profile | Register | Active Topics | Members | Search | FAQ | Send File to Tech support
 All Forums
 Origin Forum
 Origin Forum
 Export to excel

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

Screensize:
UserName:
Password:
Anti-Spam Code:
Format Mode:
Format: BoldItalicizedUnderlineStrikethrough Align LeftCenteredAlign Right Horizontal Rule Insert HyperlinkUpload FileInsert Image Insert CodeInsert QuoteInsert List
   
Message:

* HTML is OFF
* Forum Code is ON
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
millot.marius Posted - 11/09/2016 : 4:48:46 PM
Origin Ver. and Service Release (Select Help-->About Origin): 2016 b9.3.1.273
Operating System:win 7 on virtual machine

Hi
Is there a better way to export a whole workbook to a multitab excel spreadsheet than exporting each worksheet to csv ?
6   L A T E S T    R E P L I E S    (Newest First)
Hideo Fujii Posted - 01/16/2017 : 3:46:48 PM
Hi Ben Adam,

Sorry, but I don't know why the script didn't work on your machine. As far as I tested in Origin 9.0 SR2, it worked.
Please make sure that Excel has been already installed in your machine to run it.

--Hideo Fujii
OriginLab
ben.adam Posted - 01/13/2017 : 7:47:58 PM
It seems this does not work for earlier versions of Origin? I tried it for version 9 and did result in one new excel sheet and a whole number of normal origin workbooks being opened. Is there another way for earlier Origin version to achieve the same result?

Thanks

Ben Adam

Benjamin Adam
Portland State / Oregon State University
Materials Engineering
millot.marius Posted - 01/05/2017 : 5:16:15 PM
Thanks!
Hideo Fujii Posted - 01/05/2017 : 3:28:22 PM
Hi millot.marius、

You can add "label:=1" option of the wrcopy x-function in the For loop such as:

  wrcopy iw:=[%(iw$)]$(ii)! ow:=[%(ox$)]$(ii) label:=1;
though in a more general way, this outputs not only Long Name row, but also Units and Comments rows.
http://www.originlab.com/doc/X-Function/ref/wrcopy

I hope this is okay.

--Hideo Fujii
OriginLab
millot.marius Posted - 01/04/2017 : 6:28:43 PM
Hi

This works great, thank you

Would it be possible to optionally copy the longname column headers as the first row in the excel file, and to rename the Excel wksheet as the corresponding Origin worksheets ?
Hideo Fujii Posted - 11/10/2016 : 12:34:06 PM
Hi millot.marius,

Could you please try the following script?:

////////////////////////////////////////////////////
nl=page.nlayers;  //number of sheets
iw$=%H;  //Input wkbook
Menu -e 34024;  //Create an Excel wkbook
ox$=%H;  //output wkbook
for(ii=1; ii<=nl; ii++) {
  window -a %(iw$);  //Activate input wkbook
  wrcopy iw:=[%(iw$)]$(ii)! ow:=[%(ox$)]$(ii);  //Copy wksheet
}
////////////////////////////////////////////////////

which creates a new Excel workbook, data copied from the original Origin workbook,
within the Origin project. Then, you can change this Excel workbook as "External" by right-clicking
the title bar, and select Properties (or, by saving the Excel book by right-clicking the title bar,
and choose Save As).

Hope this works.

--Hideo Fujii
OriginLab

The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000