Try this code.
static void ExportExcel(Args _args)
{
SysExcelApplication ExcelApplication;
SysExcelWorkBooks ExcelWorkBooks;
SysExcelWorkBook ExcelWorkBook;
SysExcelWorkSheets ExcelWorkSheets;
SysExcelWorkSheet ExcelWorkSheet;
SysExcelRange ExcelRange;
CustTable custTable;
int row=1;
ExcelApplication = SysExcelApplication::construct();
ExcelApplication.visible(true);
ExcelWorkBooks = ExcelApplication.workbooks();
ExcelWorkBook = ExcelWorkBooks.add();
ExcelWorkSheets = ExcelWorkBook.worksheets();
ExcelWorkSheet = ExcelWorkSheets.itemFromNum(1);
ExcelWorkSheet.cells().item(row,1).value('Account num');
ExcelWorkSheet.cells().item(row,2).value('Name');
row++;
while select custTable where custtable.AccountNum like '11-000*'
{
ExcelWorkSheet.cells().item(row,1).value(custTable.AccountNum);
ExcelWorkSheet.cells().item(row,2).value(custTable.Name);
row++;
}
ExcelApplication.finalize();
}
________________________________
From: Axapta-Knowledge-Village@yahoogroups.com
[mailto:[EMAIL PROTECTED] On Behalf Of Ramanan
Seshadri
Sent: Tuesday, December 11, 2007 12:29 PM
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: Re: [Axapta-Knowledge-Village] Re: Print Reort in Exel
Dear bbarunava
I am also waiting for your answer
S Ramanan
----- Original Message ----
From: Chirani <[EMAIL PROTECTED] <mailto:ras_here2002%40yahoo.com>
>
To: Axapta-Knowledge-Village@yahoogroups.com
<mailto:Axapta-Knowledge-Village%40yahoogroups.com>
Sent: Monday, 10 December, 2007 8:09:11 AM
Subject: [Axapta-Knowledge-Village] Re: Print Reort in Exel
Barunava,
Can you explain how to do this by code.
Many Thanks,
Chirani.
--- In Axapta-Knowledge- [EMAIL PROTECTED] ups.com, Barunava Pal
<[EMAIL PROTECTED] .> wrote:
>
> Hi Febin,
> Do you want to print the report in excel instead of viewing it in
screen or print it in some printer? You can do that through code but
in that case every time that report will be printed in excel you can
not view it in screen or printer. Tell specifically about the
requirement.
>
> Barunava
>
> ----- Original Message ----
> From: febinpc <[EMAIL PROTECTED] >
> To: Axapta-Knowledge- [EMAIL PROTECTED] ups.com
> Sent: Monday, 3 December, 2007 12:54:19 PM
> Subject: [Axapta-Knowledge- Village] Print Reort in Exel
>
>
>
>
>
>
>
>
>
>
>
>
>
> hi friends
>
> i want to print one report daily basis. and i want that data in
excel.
>
> not all columns but some specified columns.for calculation purpose.
>
> how can i make it in Axapta.when i run report this excel sheet also
>
> should come up directly just like wxcel export.
>
>
>
> Thanks and Regards
>
>
>
> Febin Chiramel
>
> Mumbai
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> <!--
>
> #ygrp-mkp{
> border:1px solid #d8d8d8;font- family:Arial; margin:14px
0px;padding: 0px 14px;}
> #ygrp-mkp hr{
> border:1px solid #d8d8d8;}
> #ygrp-mkp #hd{
> color:#628c2a; font-size: 85%;font- weight:bold; line-
height:122%; margin:10px 0px;}
> #ygrp-mkp #ads{
> margin-bottom: 10px;}
> #ygrp-mkp .ad{
> padding:0 0;}
> #ygrp-mkp .ad a{
> color:#0000ff; text-decoration: none;}
> -->
>
>
>
> <!--
>
> #ygrp-sponsor #ygrp-lc{
> font-family: Arial;}
> #ygrp-sponsor #ygrp-lc #hd{
> margin:10px 0px;font-weight: bold;font- size:78%; line-height: 122%;}
> #ygrp-sponsor #ygrp-lc .ad{
> margin-bottom: 10px;padding: 0 0;}
> -->
>
>
>
> <!--
>
> #ygrp-mlmsg {font-size:13px; font-family: arial, helvetica, clean,
sans-serif;}
> #ygrp-mlmsg table {font-size:inherit; font:100% ;}
> #ygrp-mlmsg select, input, textarea {font:99% arial, helvetica,
clean, sans-serif;}
> #ygrp-mlmsg pre, code {font:115% monospace;}
> #ygrp-mlmsg * {line-height: 1.22em;}
> #ygrp-text{
> font-family: Georgia;
> }
> #ygrp-text p{
> margin:0 0 1em 0;}
> #ygrp-tpmsgs{
> font-family: Arial;
> clear:both;}
> #ygrp-vitnav{
> padding-top: 10px;font- family:Verdana; font-size: 77%;margin: 0;}
> #ygrp-vitnav a{
> padding:0 1px;}
> #ygrp-actbar{
> clear:both;margin: 25px 0;white-space: nowrap;color: #666;text-
align:right; }
> #ygrp-actbar .left{
> float:left;white- space:nowrap; }
> .bld{font-weight: bold;}
> #ygrp-grft{
> font-family: Verdana;font- size:77%; padding:15px 0;}
> #ygrp-ft{
> font-family: verdana;font- size:77%; border-top: 1px solid #666;
> padding:5px 0;
> }
> #ygrp-mlmsg #logo{
> padding-bottom: 10px;}
>
> #ygrp-vital{
> background-color: #e0ecee;margin- bottom:20px; padding:2px 0 8px 8px;}
> #ygrp-vital #vithd{
> font-size:77% ;font-family: Verdana;font- weight:bold; color:#333;
text-
transform:uppercase ;}
> #ygrp-vital ul{
> padding:0;margin: 2px 0;}
> #ygrp-vital ul li{
> list-style-type: none;clear: both;border: 1px solid #e0ecee;
> }
> #ygrp-vital ul li .ct{
> font-weight: bold;color: #ff7900;float: right;width: 2em;text-
align:right; padding-right: .5em;}
> #ygrp-vital ul li .cat{
> font-weight: bold;}
> #ygrp-vital a{
> text-decoration: none;}
>
> #ygrp-vital a:hover{
> text-decoration: underline; }
>
> #ygrp-sponsor #hd{
> color:#999;font- size:77%; }
> #ygrp-sponsor #ov{
> padding:6px 13px;background- color:#e0ecee; margin-bottom: 20px;}
> #ygrp-sponsor #ov ul{
> padding:0 0 0 8px;margin:0; }
> #ygrp-sponsor #ov li{
> list-style-type: square;padding: 6px 0;font-size: 77%;}
> #ygrp-sponsor #ov li a{
> text-decoration: none;font- size:130% ;}
> #ygrp-sponsor #nc{
> background-color: #eee;margin- bottom:20px; padding:0 8px;}
> #ygrp-sponsor .ad{
> padding:8px 0;}
> #ygrp-sponsor .ad #hd1{
> font-family: Arial;font- weight:bold; color:#628c2a; font-
size:100%;line- height:122% ;}
> #ygrp-sponsor .ad a{
> text-decoration: none;}
> #ygrp-sponsor .ad a:hover{
> text-decoration: underline; }
> #ygrp-sponsor .ad p{
> margin:0;}
> o{font-size: 0;}
> .MsoNormal{
> margin:0 0 0 0;}
> #ygrp-text tt{
> font-size:120% ;}
> blockquote{margin: 0 0 0 4px;}
> .replbq{margin: 4;}
> -->
>
>
>
>
>
>
>
>
> Share files, take polls, and discuss your passions - all
under one roof. Go to http://in.promos. yahoo.com/ groups
>
> [Non-text portions of this message have been removed]
>
Forgot the famous last words? Access your message archive online at
http://in.messenger.yahoo.com/webmessengerpromo.php
<http://in.messenger.yahoo.com/webmessengerpromo.php>
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
