SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Process a excel sheet in Emigall.

Go to solution
Former Member

‎09-06-2010 2:42 AM

0 Kudos

Hi Experts,

1. While on the Process Import File within the Emigall, under the Edit --> Data menu, there is a "Process in Excel" option. Can anyone share as to what is it used for and how to use the same?

2. Can we upload data from an Excel into Emigall like we do with a text file? If so, then do we need to follow the same format in excel as in a .txt?

Thanks,

Karan

1 ACCEPTED SOLUTION

Go to solution
Former Member

‎09-11-2010 5:14 AM

0 Kudos

Dear Karan,

The best way is while downloading the format file go to Edit -Data -download and save the file as .Xls in the system. Then process the file in the excel format, after processing, use save as option and save the excel file as .txt and then upload it in the emigall using the same path Edit-Data- Upload.

I follow this way in downloading the format, processing it in excel and uploading back to the system as .txt

Hope this helps

With Regards

Balaji.J

View solution in original post

1 REPLY 1

Go to solution
Former Member

‎09-11-2010 5:14 AM

0 Kudos

Dear Karan,

The best way is while downloading the format file go to Edit -Data -download and save the file as .Xls in the system. Then process the file in the excel format, after processing, use save as option and save the excel file as .txt and then upload it in the emigall using the same path Edit-Data- Upload.

I follow this way in downloading the format, processing it in excel and uploading back to the system as .txt

Hope this helps

With Regards

Balaji.J