02-24-2012 03:47 AM - edited 02-24-2012 03:48 AM
Hi All,
Attached labview file is use to copy the Excel datas from one sheet and create new sheet and paste the data (In Single file). What am trying to do is , Instead of creating new sheet for pasting data, I want the put the datas to the sheet which I already created as template file(Excel). I am facing problem in that. Can any1 help me.
Thanks in advance.
Thanks & Regards
Saamy
02-24-2012 03:56 AM
as I cant open your vi (i only have lv2010) a suggestion i have is read the data in then use the MSoffice report wizard which can use excel templates in the report generation toolkit
hope it helps
TD
02-24-2012 04:00 AM
Hi TD,
Thanks for the reply. Attached file is for 2010. Can u plz try this.
Thanks
02-24-2012 05:27 AM - edited 02-24-2012 05:27 AM
Hi Saamy,
If you have the Report Generation Toolkit then you can use named ranges to insert data into an excel template.
If you don't have the toolkit then maybe this thread will help:
-CC
02-25-2012 08:22 PM
Hi ChrissyC,
Thanks a lot for the info.
Now got that tool kit from your link. Can you please tell me how to use named ranges to insert data into an excel template.
For example I have excel template with two sheets (sheet names: Data and Temp). The data sheet is having some data which I have to copy to Temp sheet. when I try to use excel copy workshhet.vi its creating new sheet with the name Data(2). plz tell me how to copy the data to the temp sheet.
I have attached the sample template and labview file. Plz check the attachment.
Thanks in advance
--
Thanks & Regards
Saamy