sending to excel

(0) Share

Report

Posted on by Community Member

hi all

#1 does anybody know how to send selected rows to excel

for example i want to select certain customers from my list by holding down the Ctrl key or the shift key and send only those to excel?

i don't want to create a new list with only these customers

#2 is there a way to select 4 different random customers in my customer list and filter by these values or do i have-to manually enter the customer#|customer#| etc.

*This post is locked for comments

I have the same question (0)

All responses (14)

Answers (1)

Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

#1 : You can use filters to filter the list and export to excel using standard send to excel or you have to create a customization with custom action to create an excel for the selected rows.

#2: If you want four random customers from the list then yes you need to use filter you mentioned above i.e use NO1|NO2|....., could you explain what is your requirement here and may be we can suggest an alternate solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

what would be the customization what is the code, the procedure?

#2 when i send it to excel if my customer number starts with a zero excel will take out the zeros how do i fix that ?

Was this reply helpful? Yes No
Suggested answer

Saurav.Dhyani 14,380 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

For Customer Numbers Starting with Zero yes the Excel will trim them because you export it as Number.

While Exporting to Excel just pass the Cell Type as Text, so excel Consider it a Text not a Number then Excel will not Format it as Number.

Let us know if any issues.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

kauffmann.nl/.../export-to-excel-on-rtc-using-net-interop check this for custom solution to export to excel.

The standard Export to excel does not trim zeros are you referring to custom solution.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

yes you are right the standard excel export does not.But if i select certain rows and left click and select copy rows, when you paste it to excel, excel will trim the 0. Or maybe there is a excel macro that will do the pasting without trimming the zeros any help is appreciated.

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

Format the column as Text before you paste the rows in excel and then paste the Rows.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

is there a way to format the no. Column in dynamics NAV, as a text format, so when you copy rows in NAV it is copying a text format to excel not a number format?

Was this reply helpful? Yes No
Suggested answer

Suresh Kulla 50,243 Super User 2025 Season 2 on at

Like (0)

Report

I don't think setting on NAV will have any affect in this scenario, by default Excel has General Format so you have to change it manually in excel or check if there is any setting on excel which by default open in Text Format.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

When I tried copying random rows of our vendor table, I just did the Ctrl click thing 3 times, right-clicked, copied rows, then opened up an Excel sheet, right clicked and pasted. All came across as text. In fact, when I right-clicked in Excel it only gave me the "A" paste option (text).

Your Excel must be 'special'.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I’m using excel 2016. The random rows that you copied do any of your vendors no. start with a zero?

And if yes how do I set up excel by default to be a text format which will ultimately solve the problem

Was this reply helpful? Yes No