Writing to excel file Exception from HRESULT: 0x800A03EC

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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

Categories:

Power Automate Desktop

I have the same question (0)

All responses (6)

Answers (1)

XRQ57 206 on at

Like (1)

Report
Copy link

Link copied!

Hi,
can you share the flow?

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Daniel_Pa 244 on at

Like (1)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

Zave 88 on at

Like (2)

Report
Copy link

Link copied!

Hi,
I'd suggest changing the row from 0 to 1, for the "Write to Excel worksheet" action.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
HugoRopberto 3 on at

Like (0)

Report
Copy link

Link copied!

Really the comment in this case belong to a "missed Drive letter"; so the explaination provided is fine, obviouly with the Monday Newspaper.

Was this reply helpful? Yes No