![]() System.IO.File.Copy(sourceFile,destFile,true) 'I copy the original file to the new location SourceFile = System.IO.Path.Combine(sourceDir,fileName) InTouch:$Hour+ "" + InTouch:$Minute + ".xls" SourceDir = "C:\MIGRA\SCADA\Acesur_Cogeneracion" ĭestName = InTouch:$Day + "" + InTouch:$Month + "" + InTouch:$Year + "_" + ![]() After that I use the function WWPoke() to insert the desired values into Excel. The code I'm using is below, here you can see that I'm copying the excel file to a new location changing it's name and I open the new excel file. So my questions are this: Does anyone know how to export this data to an excel spreadsheet using the vb.net of Intouch Archestra Graphics? If not, is it possible to export data to excel from SQL Server with a SQL Query? When I try to generate the report with this computer it makes everything right except writting into the cells. The thing is that the code I'm using is working with Office 2010 which is the version I have in my computer, but when I installed the SCADA in the new computer, we bought a licence of Office 2016. The report it's simply writting 10 values into specific cells. ![]() In this SCADA I have to make some reports in excel. I'm programming an SCADA with Intouch R2 SP1.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |