Jump to content
Sign in to follow this  
SiteMaze

Paste CSV into Excel

Recommended Posts

SiteMaze

I would like to paste 1-CSV to Excel Worksheet-1, then 2-CSV to Excel Worksheet-2, and so on.

Can someone help with the COM?

I couldn't find it in ExcelCOM UDF and prefer not to add cell by cell.

Thanks!

Share this post


Link to post
Share on other sites
SiteMaze

; 1-CSV

_ExcelSheetActivate($oExcel, "1")

$f_2arr_CsvFile = _CSVto2DArray($glb_str_RunFiles&"\1.csv")

_ExcelWriteSheetFromArray($oExcel, $f_2arr_CsvFile)

; 2-CSV

_ExcelSheetActivate($oExcel, "2")

$f_2arr_CsvFile = _CSVto2DArray($glb_str_RunFiles&"\2.csv")

_ExcelWriteSheetFromArray($oExcel, $f_2arr_CsvFile)

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

×