alapolloni / excelrefresh Goto Github PK

Changes in SharePoint mean that office files are by default opened read-only, therefore ExcelRefresh will fail to save. Adding a call to theWorkbook.LockServerFile(); did the trick for me.

Would be great if you could include error codes from the excellent little app. I am using it in a batch file and trying to catch errors with %errorlevel% variable. Even if file is missing %errorlevel% is always set to 0 in the batch job.

Some errors that would be great to catch:

• File is missing
• File is locked for updates (opened in excel by other application)
• ...

Hello,

i have add the batchfile as Task on Windows 10 but wont work. When i start the bat manually this works.

Someone have same Problem?

Trying to refresh a file that's connecting to a SQL Server via odbc connection.
Raised the error :

C:\Users\etieti\Downloads>ExcelRefresh.exe -d -c -q -f "J:\QUALITA'!ISO 9001\05 MODULI!Intestazioni per moduli!Intestazioni Per Moduli-1.xls"
Filename: J:\QUALITA'!ISO 9001\05 MODULI!Intestazioni per moduli!Intestazioni Per Moduli-1.xls
Items Count: 0
Input File Full Path: J:\QUALITA'!ISO 9001\05 MODULI!Intestazioni per moduli!Intestazioni Per Moduli-1.xls
WorkSheets:
Foglio1
Foglio2
Foglio3
Connection refresh: Query da alnus

Eccezione non gestita: System.Runtime.InteropServices.COMException: Eccezione da HRESULT: 0x800A03EC
in System.RuntimeType.ForwardCallToInvokeMember(String memberName, BindingFlags flags, Object target, Int32[] aWrapperTypes, MessageData& msgData)
in Microsoft.Office.Interop.Excel.WorkbookConnection.get_OLEDBConnection()
in XLRefresh.Program.refreshConnection(Workbook theWorkbook)
in XLRefresh.Program.Main(String[] args)

@alapolloni I'd like to use to refresh documents at work, but won't be considered for internal use until an open source license is specified. Many thanks!