* Convert incoming CSV data into a range and add it to the workbook.įunction main(workbook: ExcelScript. This sample assumes the folder is named "output".Īdd the following script and build a flow using the steps given to try the sample yourself! Sample code: Insert comma-separated values into a workbook /** Extract the files into a folder in your OneDrive. To create separate csv files for each worksheet you may use powershell, sample is here Convert Excel file (XLSX) to CSV in Powershell, or similar VBA script, or manually: right click on sheet, Move or Copy, check Copy, from destination select new book and from it save as csv. csv files and pass their contents to the script.ĭownload convert-csv-example.zip to get the Template.xlsx file and two sample.
0 Comments
Leave a Reply. |