Excel Board

[64864050]

hi, don know whether am i in the right topic.

anyway, i would like to ask, is it possible for this report generation tookit to read from specific sheet in excel and write to a specific sheet?

i already have a template with quite a number of sheet, and all of them is formatted

so i want to read the data from the specific sheet and display in my labview table

and

i also wan to write the data to a specific sheet in the excel file.

is it possible?

[smercurio_fc]

Please re-read the purpose of this thread. This thread is not for questions. It is a repository of links only. Please ask your question in the LabVIEW board.

[aeastet]

Here I show the Chrat Wizzard Function for Excel

http://forums.ni.com/t5/LabVIEW/labview-excel-2007-Axis-title/td-p/1226794

[Wayne.C]

When printing a long Excel Report, often desirable to repeat a header at top of each printed page.  Here is how to set the 'Rows to repeat at top:' setting in page setup for worksheet.

[Wayne.C]

When inserting timestamps into Excel, it is often necessary to apply a custom format to the cells.  Here is an example that uses ActiveX and the Report Generation toolkit to format a range of cells for a custom timestamp.

[Wayne.C]

Sometimes we just want everything.  This snippet shows how to grab all data from an Excel worksheet.

[trosier]

I have to post this one as I have been getting it all together for a while now. I have a VI using ActiveX that will:

-->Open up Excel

-->Copy the sheet specified by Master Sheet Name

-->Rename the copied sheet according to New Sheet Name

-->Move that newly named sheet to the end (right most position) of all the sheets.

[smercurio_fc]

Please re-read the purpose of this thread. This thread is NOT for questions. It is a repository of links only. I also told you this in your original thread.

[trosier]

SMERCURIO FC - If your last post was directed at someone other than me please disregard this post. However being that it was right after I made my post please READ what I posted. This is an example that I wanted to share here as a solution for something I have been investigating for a while now. It is a solution that I came up with between other posts and talking with NI. I felt it would be something useful for this thread. It is NOT a question it is a post with a solution to using Labview with ActiveX to manipulate an Excel Workbook.

[smercurio_fc]

---

@trosier wrote:

SMERCURIO FC - If your last post was directed at someone other than me please disregard this post. However being that it was right after I made my post please READ what I posted. This is an example that I wanted to share here as a solution for something I have been investigating for a while now. It is a solution that I came up with between other posts and talking with NI. I felt it would be something useful for this thread. It is NOT a question it is a post with a solution to using Labview with ActiveX to manipulate an Excel Workbook.

---

You're right. I misread your post. My apologies.