Hi everyone
I have a list with sub lists. I am trying to export the data from the list to make it usable in excel. Is there a package i can download that can do this for me. Can someone guide towards a solution?
Thanks!
Ideally Data.OpenXMLExportExcel is the node to use as it is most robust and foolproof. But that isn’t available then Data.ExportToExcel will work if you have a functional version of excel with working API access.
I tried data.exporttoexcel and was wondering if i run the graph it produces an excel. then if i clear the sheet and close the excel window, how come when i run dynamo again excel doesnt open?
Excel doesn’t always open - in fact if you configure the graph correctly it won’t open at all.
That said if you aren’t providing data to the node after “clearing the sheet” then it won’t write anything.
What can I do to ensure every time i run the graph, a excel file opens with the data?
Ensure that the input into the excel node changes on each run. This would likely require generating a random file name.
How do i generate a random file name? is this something that can be automated?
You could take the current time (DateTime.Now() and append it to a string to get a unique name for each run.
You could use a Math.Random node or series thereof.
You could use a GUID generator.
You could…
What is the end goal?