Juvigy
-
Posts
1,804 -
Joined
-
Last visited
-
Days Won
1
Community Answers
-
Juvigy's post in Excel issue with Range.Value was marked as the answer
Managed to implement this with:
$oExcel.Application.ActiveWorkbook.Activesheet.Range("A252:A255").FormulaR1C1 = '=INDIRECT("O"&ROW())/INDIRECT("AE"&ROW())/INDIRECT("AF"&ROW())'
-
Juvigy's post in SQL upload XLS file to a SQL table was marked as the answer
It is an excel connection string issue. The solution is this:
''Provider=Microsoft.ACE.OLEDB.12.0;Data Source=' &$filename&';Extended Properties="Excel 12.0 Xml;HDR=YES;IMEX=1;'"
Instead of this:
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\111.xls;Extended Properties=Excel 8.0"
