Baanboard.com

Go Back   Baanboard.com > Forum > CMS - Forum Integration > Blogs and Web links

User login

Frontpage Sponsor

Main

Poll
How big is your Baan-DB (just Data AND Indexes)
0 - 200 GB
18%
200 - 500 GB
28%
500 - 800 GB
3%
800 - 1200 GB
8%
1200 - 1500 GB
8%
1500 - 2000 GB
12%
> 2000 GB
24%
Total votes: 78

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 15th September 2014, 17:57
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 244
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
Excel Report with color and other formats

A new blog entry has been added:

Excel Report with color and other formats

Quote:
Excel one of the most widely used S/W, it’s the best tool for analysis. Most of the end users like the reports in excel. Many time they prefer having highlights for important data ( Like Colours , Bold and  Italic ETC) ,What would you do when you are supposed to format the report in excel. Probably depending on the importance of the requirement & Man/hours required, you would decide from the following 
1)      Creating a CSV file with no formatting, saying it’s not possible to generate formatted report (possible not aware the formatted report can be generated with VBS-Macro or Spreadsheet ML) .
a.        Now even creating CSV file has its own challenges because different regions have different REGIONAL SETTING with in the client system for Example : In USA  the CSV file is Comma Separated Value but where as in Germany CSV is semicolon Separated Value, it’s not just the separator but also the Numeric representation changes. Since this not being the main topic leaving it here ;)
__________________
Regards,
Vamsi
Reply With Quote
Sponsored Links
  #2  
Old 16th September 2014, 09:07
pillai.ganesh's Avatar
pillai.ganesh pillai.ganesh is offline
Senior Member
 
Join Date: Apr 2011
Location: United Arab Emirates
Posts: 105
pillai.ganesh is on a distinguished road
Baan: ERP LN 6.1 - DB: Oracle, SQL, Informix - OS: Windows
Thanks!!

Thanks for the post Vamsi.
Reply With Quote
  #3  
Old 29th August 2016, 13:38
Ajesh's Avatar
Ajesh Ajesh is offline
Guru
 
Join Date: Feb 2009
Posts: 646
Ajesh is on a distinguished road
Baan: LN 10.4 - DB: Oracle - OS: HP-Unix
so does this sequence of code directly writes the data into xlsx format?
Reply With Quote
  #4  
Old 30th August 2016, 22:41
vamsi_gujjula's Avatar
vamsi_gujjula vamsi_gujjula is offline
Senior Member
 
Join Date: Nov 2011
Location: hyderabad ; india
Posts: 244
vamsi_gujjula is on a distinguished road
Baan: ERPLN fp3 and 10.4 - DB: oracle - OS: Aix , Redhat linux 6
its writes an XML file.
__________________
Regards,
Vamsi
Reply With Quote
  #5  
Old 31st August 2016, 11:23
BChary's Avatar
BChary BChary is offline
Junior Member
 
Join Date: Apr 2016
Location: Poland
Posts: 17
BChary is on a distinguished road
Baan: Infor LN 10.4/10.5 - DB: SQL Server - OS: W10
After using session to generate xml, you can use command:
Code:
start.application.local("excel path\file.xml", false, exitcode)
to open xml as excel file.

Last edited by BChary : 31st August 2016 at 11:40.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Forum Jump


All times are GMT +2. The time now is 04:41.


©2001-2018 - Baanboard.com - Baanforums.com