Excel error

Like (0) Share

Report

Posted on 5 Oct 2017 23:27:31 by Community Member

I have a report which populates data and exports it to excel.

Report contains the following line:

Sheet.Range(excelString[i]+FORMAT(excLine+COUNT+3)).Formula:='=COUNTIF('+excelString[k]+FORMAT(excLine)+':AR'+FORMAT(excLine)+';"'+CA.Code+'")*8'

excelString[i],excelString[k] has a value of a colum for example D, and the rest are numbers.

This is worrking on some excels. For example i have a two machines with office 2013 Proffesional Plus.

On the first excel is populated, on the second it gives the error attached.

The only difference is regiona settings: Language.

6116.err.png

*This post is locked for comments

All responses (7)

Answers (3)

Shristi 25 on 23 Jan 2021 at 20:40:21

Like (0)

Report

RE: Excel error

HI, Nermina Pzz verify which solution has worked for you.
Suggested answer

Binesh 7,885 on 09 Oct 2017 at 04:51:03

Like (0)

Report

RE: Excel error

Hey Nermina,

If your problem is fixed then Verify the answer so it can be helpful for others member also.
Community Member on 07 Oct 2017 at 19:56:17

Like (0)

Report

RE: Excel error

Yes, this was the solution. Thank you!
Verified answer

Binesh 7,885 on 06 Oct 2017 at 09:04:59

Like (0)

Report

RE: Excel error

Hello,

Has the Office installation on the problem workstation been activated yet?

I think some automation issues on your PC.

Need to re-activate Office. After re-activating, the issues resolved.
Verified answer

4BzSoftware 6,071 on 06 Oct 2017 at 08:57:40

Like (0)

Report

RE: Excel error

Hi Nermina,

Hope comment below code line of table 370 Excel Buffer help you:

XlHelper.AutoFitColumnsInAllWorksheets(XlWrkBk);
Community Member on 06 Oct 2017 at 06:08:48

Like (0)

Report

RE: Excel error

NAV TABLE EXPORT or PRINT TO EXCEL

Go to Department>Administration>IT Administration>General>Manage style Sheet

Choose Style sheets Common to all > Action>Import>Style Sheet

In search option put .xsl and enter then find then select

Navision From To Excel

In send To Program option

Create EXCEL.EXE as executable and Name as Microsoft EXCEL
Verified answer

Alexander Ermakov 28,094 on 06 Oct 2017 at 00:08:47

Like (0)

Report

RE: Excel error

Can it be the case that the delimiter is also different in the regional settings?