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
 Automatically import .cdf files, 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
Corsa88 Posted - 07/01/2016 : 10:44:35 AM
Origin Ver. and Service Release (Select Help-->About Origin): OriginPro 2015 64 bit
Operating System: Windows 10 Home 64 bit

Hi

I have a bunch of .cdf files that I need to extract its data from. Since Excel does not natively support .cdf, I rely on Origin to view and extract the data stored in the .cdf file and manually copy and paste them into Excel.

Since I have quite many of these .cdf files, is there any way for me to automatically import them into Origin and to extract its contents into Excel?

Thank you all in advance.

Regards
Ben
3   L A T E S T    R E P L I E S    (Newest First)
Corsa88 Posted - 07/07/2016 : 05:36:31 AM
Hi Shirley

Thank you for the script. Is it possible to only add in certain data columns to import, in order to reduce the file size and processing time?

Also, I have tried the script and it works. Would it be possible to name the output file as the input file name?
gregorybelger52 Posted - 07/07/2016 : 05:29:27 AM
Oh it's really timing that we got the same issue, I expect the use and effectivenessof of this script. When I got home I'll try this. Thank you so much!

http://www.safeharborfi.com/about-us/
Shirley_GZ Posted - 07/05/2016 : 01:38:41 AM
Hi Corsa88,

You can import multiple CDF files to Origin and then export them as CSV files from Origin. To do this automatically, please try the script lines below:

string fns, path$="C:\CDF\";
findfiles fname:=fns$ ext:="*.cdf";
impCDF fname:=fns$; //Import all CDF files in folder C:\CDF
//Export each worksheet in current project as CSV files
doc -e LB
{
expASC type:=csv path:="C:\CSV\[%H]%(page.active$).CSV";  
}


It might take some time if there are many cdf files and each file is large.

Once these data been exported as CSV files, you can do further analysis in Excel.

Thanks,
Shirley


Originlab Technical Service Team

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