LabVIEW
Opening an Excel Workbook using .NET
@alexderjuengere wrote:
wiebe@CARYA wrote:
After 4 hours of debating with copilot, I found a (quite simple) solution for the failing Workbooks.Open.
apparently, the ki doesn't know about
https://forums.ni.com/t5/LabVIEW/Darren-s-Occasional-Nugget-09-26-2022/td-p/4257604
That's a very limited solution though.
For instance, I want (or rather, I'm required to) to open a workbook and print a range of worksheets.
Search LabVIEW like a graph! 
wiebe@CARYA wrote:
@alexderjuengere wrote:
wiebe@CARYA wrote:
After 4 hours of debating with copilot, I found a (quite simple) solution for the failing Workbooks.Open.
apparently, the ki doesn't know about
https://forums.ni.com/t5/LabVIEW/Darren-s-Occasional-Nugget-09-26-2022/td-p/4257604
That's a very limited solution though.
For instance, I want (or rather, I'm required to) to open a workbook and print a range of worksheets.
You still could read the data with Darrens function or an improved version of it and display it in a LabVIEW table and print that. 😁
Just saying.
@rolfk wrote:
wiebe@CARYA wrote:
@alexderjuengere wrote:
wiebe@CARYA wrote:
After 4 hours of debating with copilot, I found a (quite simple) solution for the failing Workbooks.Open.
apparently, the ki doesn't know about
https://forums.ni.com/t5/LabVIEW/Darren-s-Occasional-Nugget-09-26-2022/td-p/4257604
That's a very limited solution though.
For instance, I want (or rather, I'm required to) to open a workbook and print a range of worksheets.You still could read the data with Darrens function or an improved version of it and display it in a LabVIEW table and print that. 😁
Just saying.
No, not really.
We get an excel file from the customer that does a lot of calculations. The sheets to be printed are made by the customer and quite decorated.
So, technically we could, practically, we can't. We'd have to make an user interface that allows the customer to change the calculations and the report layout.
I usually prefer reporting from LabVIEW but in this case we're simply going to let Excel do the calculations.
I am going to use the mentioned OOXML library to fill the sheets (so that keeps on working if there's no Excel installed), but we'll let Excel do the calculations and printing.
