topic Re: Excel Sheet problem in Application Development and Automation Discussions

Excel Sheet problem

Former Member — Tue, 04 Sep 2007 13:36:24 GMT

Hi Frnds,

When I am Displaying Time field in excel sheet the format is changing the field reference I am using is TVRO-FAHZTD, i wnt to print time in HHHHH:MM format

Thanks,

Y.ravi kumar

Message was edited by:

ravi kumar

Re: Excel Sheet problem

Former Member — Tue, 04 Sep 2007 13:44:13 GMT

Hi,

Declare the reference field as charachter you will get the correct output.

Before moving to the final internal table format your time according to your requirement using EDIT MASK.

Reward if helpful.

Re: Excel Sheet problem

Former Member — Tue, 04 Sep 2007 13:44:33 GMT

When you send values to Excel, your excel settings changes the format.

So contatenate a ' (single colon) to the values you are sending, then Excel will consider it as string and it'll not change the format.

Regards

Surya.

Re: Excel Sheet problem

Former Member — Tue, 04 Sep 2007 13:47:12 GMT

Hi,

This is depends on the Excel sheet format, please change the excel sheet format

Regards

Sudheer