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
Username:
 Password:
Save Password
Forgot your Password? | Admin Options

 All Forums
 Origin Forum for Programming
 LabTalk Forum
 import Excel to a non-empty sheet?		  New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic

coll@inia.

Spain
125 Posts
Posted - 05/07/2011 :  07:51:28 AM  Show Profile  Edit Topic  Reply with Quote  View user's IP address  Delete Topic
Origin Ver. 8 prof WXP:

Is it possible to import excel files with the impExcel function in the same sheet which is open in Origin and already contains data on it?.

I tried differnt options and none seems to work. The excel values are always imported to a new sheet and renamed!.

Also I would like to delete by code the log window (and sometimes the script window) that appear after the import, could it be done?

Thank you for your attention, julio

AmandaLu

439 Posts
Posted - 05/09/2011 :  02:37:16 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
Hi,

Right now there is no easy way to import excel to an existed worksheet. To do this, you can first import excel file to a new book or sheet by impExcel, and then copy and paste it to the existed sheet using some scripts.

To turn off the import message dump to the Results Log window, please uncheck the Results Log Output checkbox in the import X-Function dialog. If using LabTalk script to import, impExcel for example, you can use

impExcel -sl fname:="F:\OriginLab\Origin8\Samples\Graphing\Excel Data.xls" desig:=<Unchanged>;
to import excel without dumping results to Results Log.
Edited by - AmandaLu on 05/09/2011 02:38:28 AM
Go to Top of Page

coll@inia.

Spain
125 Posts
Posted - 05/09/2011 :  06:58:07 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
dear Amandalu,
I checked your suggeste -sl & desig:=<Unchanged> options on ImpExcel. They work Ok together with the default turning out Results Log Output. Many Thanks!.

With respect to opening the excel into the same sheet, the funny thing is that it happened to me in one computer but not in the other. I try many different combinations, but it seems the information is on the Book I used in the computer where it happened. I still could not tested in the other computer. I cannot detect any other possibility by now but that the Book is "special". When I import excel data on this "special" book (not in others), it looks different with a smaller size of the cells. Woulod that come from a first excel import by the regular method ratehr than the code?.I Have transfered all the text-attached commands to the special book and import the excels into the active sheet. I do not know yet why is it working!!. . Any ideas?

greetings, julio
Go to Top of Page

AmandaLu

439 Posts
Posted - 05/10/2011 :  03:56:28 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
I tried to reproduce the importing Excel problem but failed. Could you please send the following files so that I can try to reproduce the problem on my machine, and to figure out what went wrong?:

1) Your Origin project in which this problem happened, and some Excel files you used to import.

2) Scripts used to import Excel.

3) Exact step-by-step procedure to reproduce the problem.

Please refer to this post in your email.

We are sorry for the inconvenience, but please understand that first. it should be done is to reproduce the problem here.
Go to Top of Page

coll@inia.

Spain
125 Posts
Posted - 05/10/2011 :  06:57:29 AM  Show Profile  Edit Reply  Reply with Quote  View user's IP address  Delete Reply
dear Amandalu,
Thank you for your interest.
No problem to send you the files. They will be shortened because they come from microarray data with about 3000 rows. I will do it following this note.

I will send the *opj which is now working. I still do not know why!.

I am now trying to automatically plot selected rows (100-200) corresponding to different type of genes in different Graphs into bar plots with Col(A),Col(B) and Col(C) for mean, sd and label. I remember having those easily done in the past (Origin6), but now the same commands do not work in O8. Furtehrmore it si much more dificult to find the right commands to do a simple layer of col(B)!! on a graph. Could you help me with those also?

thanks, sincerely.
Go to Top of Page
  Previous Topic Topic Next Topic Lock Topic Edit Topic Delete Topic New Topic Reply to Topic
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
The Origin Forum © 2020 Originlab Corporation Go To Top Of Page
Snitz Forums 2000