how to separate the each excel worksheet

[GokulGKM]

hi,

how to separate the each excel worksheet in single workbook.

[altenbach]

Please explain how this question relates to LabVIEW.

It always helps to provide as much detail as possible.

[GerdW]

Hi Gokul,

---

@GokulGKM wrote:

how to separate the each excel worksheet in single workbook.

---

Right-click the worksheet tab in Excel, select move/copy and move it into its own (new) workbook…

Maybe you want to ask in an Excel forum?

[GokulGKM]

through labview i need to separate the worksheet form excel.

[GerdW]

Hi Gokul,

---

@GokulGKM wrote:

through labview i need to separate the worksheet form excel.

---

1. Some steps you need to take:
2. open the exisiting workbook
3. get a list of all sheets (and their names)
4. for each sheet in workbook: read the sheet data and write to new workbook

Which of the steps is a problem for you?

(I don't have MicrosoftOffice installed on this computer, so I cannot run your VI with its RGT functions…)

[PsyenceFact]

Hi GokulGKM,

I can't open your file as I'm still using LV2015, but I've put together a quick example which should give you the right idea.

It opens the original file as read-only then makes a copy of each worksheet in a new workbook.  If you want to move rather than copy, just change the Worksheet.Copy method in the loop to Worksheet.Move - the syntax remains the same.  I haven't added any code to save the new workbooks so you can add it yourself or just save them manually as you require.

Hope this is useful.

PsyenceFact

[GokulGKM]

Cannot Find "Excel.Application" Reference in LabVIEW.

but still can able  to run your VI.but i can't able to edit or add property node.

[GokulGKM]

Even tried like this method also it's not showing.

[GokulGKM]

more information,

windows 10 OS with 64 bit 

Microsoft office 64 bit 

Labview 2016 32 bit

i can't able to convert labview and Microsoft office as same bit version.

[PsyenceFact]

Since you are using the Report Generation Toolkit VIs to obtain the initial ActiveX references, you don't need the Automation Open node.  Wire the Excel._Application output from Get ActiveX References.vi straight to the _Application.Workbooks property node.  You should also replace the close Application reference with Dispose Report.vi.

PsyenceFact