satheeshv
22nd September 2014, 12:23
Hi All,
when we Report output to excel, we have to do manually delimited the report output.
Is their any possibility to do delimited automatically in when report output is saved in excel?
Can you please help me on this, It is bit urgent.
Thanks in advance for help.
Regards,
Sathish
bhushanchanda
22nd September 2014, 12:33
Hi,
There can be 4 solutions.
1. Follow following links. If anyone of the following pelps, its well and good.
Thread 1 (http://www.baanboard.com/baanboard/showthread.php?t=47901)
Thread 2 (http://www.baanboard.com/baanboard/showthread.php?t=61669)
Thread 3 (http://www.baanboard.com/baanboard/showthread.php?t=49427)
Thread 4 (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=1546)
2. You can use ~Vamsi's BaanXL way of doing it.
BaanXL (http://www.baanboard.com/baanboard/showthread.php?s=&threadid=5880)
3. Create your own device which rewrites data to a new file with proper delimiters.
4. Write your data to a file using seq.* functions directly.
satheeshv
22nd September 2014, 14:36
Dear Bhushanchanda,
Thanks for your help, It is working fine.
Regards,
Sathish
bhushanchanda
22nd September 2014, 14:39
Hello,
Glad that helped. Please post your solution, so that others having the same issue will get some help.