09-09-2016 03:38 AM
Hi, guys.
I have a question about deal with data in Excel,
I had determine two cell's address(eg A1, C20), then select the data(eg. within A1 to A20 and C1 to C20) to other sheet(or table).
Thx.
Solved! Go to Solution.
09-09-2016 03:42 AM
Is your requirement is to copy contents of specified range from one sheet to another sheet?
how do you want to achive that? 1.ActiveX 2.Report Generation ToolKit
09-09-2016 03:48 AM
PalanivelT 已写:Is your requirement is to copy contents of specified range from one sheet to another sheet?
how do you want to achive that? 1.ActiveX 2.Report Generation ToolKit
Yes, one sheet to another sheet, other I want to use ActiveX.
09-09-2016 04:00 AM
Please find the attached Files, I am working on it to create a excel using activex for all the sceanarios but its in progress
but it is sufficient for your requirement i hope.
09-09-2016 04:11 AM
PalanivelT 已写:Please find the attached Files, I am working on it to create a excel using activex for all the sceanarios but its in progress
but it is sufficient for your requirement i hope.
Thank you, Palanivel T, I try to use the files to solve my problems.
09-09-2016 04:16 AM
Its an single run VI you need to call the same VI sequentially by providing options in proper order.
Open Excel
Create Workbook
Open WorkBook etc.,
Close Ref once your job is done.
09-09-2016 03:49 PM
@Erbin wrote:
PalanivelT 已写:Is your requirement is to copy contents of specified range from one sheet to another sheet?
how do you want to achive that? 1.ActiveX 2.Report Generation ToolKit
Yes, one sheet to another sheet, other I want to use ActiveX.
I'm guessing that you don't have access to the Report Generation Toolkit. To do what you propose is pretty simple using the RGT ...
Bob Schor
09-11-2016 08:26 AM
09-11-2016 01:15 PM
Hi, there is a easier way to do get the data you want: just use Excel Get Data.vi in the RGT->Excel specific. You just need to specify the start cell and the end cell.
09-11-2016 03:01 PM
That's easier if they want to purchase a license. It sounds like they don't have access given they stated they wanted to work with ActiveX over the RGT