Writing to excel file Exception from HRESULT: 0x800A03EC

Like (0) Share

Report

Posted on 4 Jan 2022 12:30:23 by Community Power Pla...

Writing to excel file throws error Exception from HRESULT: 0x800A03EC

All responses (6)

Answers (1)

HugoRopberto 3 on 22 Nov 2023 at 12:02:40

Like (0)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

Really the comment in this case belong to a "missed Drive letter"; so the explaination provided is fine, obviouly with the Monday Newspaper.
Community Power Pla... on 04 Jan 2022 at 15:08:51

Like (1)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

mind blowing.... who would have thought? Thanks a lot!
Verified answer

Zave 88 on 04 Jan 2022 at 14:19:39

Like (2)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

Hi,
I'd suggest changing the row from 0 to 1, for the "Write to Excel worksheet" action.
Daniel_Pa 244 on 04 Jan 2022 at 13:49:45

Like (1)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

A quick google search indicates that the error can be related to several things in Excel: "The error code
0x800A03EC (or -2146827284) means NAME_NOT_FOUND; in other words, you've asked for something, and Excel can't find it."

Could it be that what you are trying to write to Excel does not conform to the size or format of the sheet? I see that you populate the DownloadedFiles-variable with other variables - this might be part of the issue? Could be that the list is longer than what fits into the sheet or the format isn't accepted?
Community Power Pla... on 04 Jan 2022 at 13:35:46

Like (0)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

Sure! - there are a couple of booleans.... but you can ignore the ifs part.
Thanks!

Excel.LaunchExcel.LaunchAndOpen Path: DocumentsUploadedFilePath Visible: False ReadOnly: False LoadAddInsAndMacros: False Instance=> UpdateReport
Excel.ReadFromExcel.ReadAllCells Instance: UpdateReport ReadAsText: False FirstLineIsHeader: True RangeValue=> DownloadedFiles
Excel.CloseExcel.Close Instance: UpdateReport
LOOP FOREACH CurrentDownloadedFile IN DownloadedFiles
IF CurrentDownloadedFile[0] = SalesNatXMLFilePath THEN
DISABLE SET DownloadedFiles[LoopRowCount - 2] TO FileNat
SET boolNewFileNat TO $'''False'''
END
IF CurrentDownloadedFile[0] = SalesJudXMLFilePath THEN
DISABLE SET DownloadedFiles[LoopRowCount - 2] TO FileJudStatus
SET boolNewFileNat TO $'''False'''
END
Variables.IncreaseVariable Value: LoopRowCount IncrementValue: 1 IncreasedValue=> LoopRowCount
END
IF boolNewFileNat = $'''True''' THEN
SET DownloadedFiles TO DownloadedFiles + [SalesNatXMLFilePath, FileNatStatus, Date]
Variables.IncreaseVariable Value: LoopRowCount IncrementValue: 1 IncreasedValue=> LoopRowCount
END
IF boolNewFileJud = $'''True''' THEN
SET DownloadedFiles TO DownloadedFiles + [SalesJudXMLFilePath, FileJudStatus, Date]
END
WAIT 2
System.TerminateProcess.TerminateProcessByName ProcessName: $'''EXCEL'''
WAIT 2
Excel.LaunchExcel.Launch Visible: False LoadAddInsAndMacros: False Instance=> WriteUpdate
Excel.WriteToExcel.WriteCell Instance: WriteUpdate Value: DownloadedFiles Column: $'''A''' Row: 0
Excel.SaveExcel.SaveAs Instance: WriteUpdate DocumentFormat: Excel.ExcelFormat.FromExtension DocumentPath: DocumentsUploadedFilePath
Excel.CloseExcel.Close Instance: WriteUpdate
XRQ57 206 on 04 Jan 2022 at 13:05:55

Like (1)

Report

Re: Writing to excel file Exception from HRESULT: 0x800A03EC

Hi,
can you share the flow?