Error
BC30512: An implicit conversion from ‘IWorkbookQuickHandle’ to ‘String’ is not allowed with Option Strict On. The selected value does not match the property’s type.
I want to transfer data from a CSV file to an Excel file,
but I’m encountering an error with the Write Range (Workbook) activity.
Additionally, since I am not using OneDrive / SharePoint, I cannot use the Write Range activity.
Hello
If you want to write to a file set with the Use Excel File activity, please try using the “Write Range” activity.
Hello,
Activities like the Write Range (Workbook) activity, which have (Workbook) in their name, are designed to read and write Excel files without starting Excel, so they should not be placed inside Excel Application Scope activities.
Please move the Excel file outside of the Excel Application Scope activity, or if you want to use it within that scope, please use a different WriteRangeX activity.
Hello
Please enable “Save Changes” when using the Excel file or try using the activity to explicitly save the workbook.
Thank you very much!
Thanks to you, I was able to do it!
I look forward to working with you again.
Thank you very much!
This is very informative!!
Thank you for your support.
I want to write to a different CSV file in a separate Excel file within the same flow.
I copied the previous one to create it, but it didn’t work well.
Is there something wrong?
Thank you in advance.
[Error] Writing Data Table to Excel: Object reference not set to an instance of an object.
Isn’t dt_csv2 empty?
Are you specifying dt_csv2 in the CSV reading?
