09-13-2010 01:10 PM
Well, you always have control to write the data into excel file, you can write 500 rows of data in page 1 and then move to page 2 and similarly page 100 if you want to.
As far as I see you read the data from from database and dump the same data to the excel file,. you can write how much ever data you want to correct ? Tryout programming in this fashion.
09-13-2010 01:25 PM
Here is the vi I am working with. It is saved to the frame where the column headers are created. The next frame is a for loop which first gets the next database record, then applies it to the report.
09-13-2010 01:54 PM
This is a fictional worksheet generated by the vi to show what it will look like.
09-13-2010 01:55 PM - edited 09-13-2010 02:01 PM
Alright, Instead of using Increment Column VI use the "EXCEL EASY TEXT.VI " to update your column name and make use of start and end index to control your column index. This will avoid the use of basic report generation API.
Looks like you have lots of column to update, but I can see that you have sequence inside sequence inside sequence, you can really modify the logic and come up with better ones.
Well in my earlier reply I meant use the EXCEL EASY TEXT VI to update the column names, and since you get the data from the database you can write data in a loop at once instead of writing into variable and then writing into excel sheet.Use "EXCEL EASY TABLE" to write the data into excel file at once, remember to properly program the start and end inputs.
Attaching the excel sheet generated from my program and see the wonders what we can do from NI report generation toolkit
Have attached some programs of my project
09-13-2010 01:59 PM
Awesome! I think you have put me on the right track. I will try your suggestions and post back.
Thank you!
09-13-2010 02:46 PM
SciManStev,
Do the headers just need to show up when the report is printed?
09-13-2010 02:48 PM
Yes. Only when the report is printed. Several copies of the report are passed out at meetings for review. On the monitor itself, I don't care.
09-13-2010 02:55 PM - edited 09-13-2010 02:56 PM
SciManStev,
Very easy way to do this. In Excel its called 'Rows to repeat at top:' You can access the setting using ActiveX. I've attached a simple example that sets Row1 of worksheet to be repeated at top of each printed page.
09-13-2010 03:01 PM
I think that is just perfect! I was hoping it would be that easy! Thank you both very, very much!
02-26-2013 03:05 AM
I have exported the table with "excel specific vi's" with column headers data at the top of the 1 st page. but, I want to add column headers to each page of the excel report programmatically.
Can anyone give me the answer.