We have not had any problems with these methods on our XP clients (we still
run SP1 exclusively, I couldn't comment on SP2).
However in terms of maintenance and using standard Axapta I would still
suggest using the html/xls trick if all you want to do is generate standard
reports in Excel. The nice thing about this method is that you benefit from
the standard visual report layout (ie you get all the formatting in Excel).
If you just want figures to manipulate, I would suggest going text/csv.
Excel can easily read these files, and is usually the default application
for opening them (so your users can still double-click the files to open
Excel as if they were xls files).
Regards,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com <http://www.smallfrymobile.com>
-----Original Message-----
From: Brandon George [mailto:[EMAIL PROTECTED]
Sent: 29 March 2005 04:38 PM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Open a excelfile
We at are company are BIG excel users for reports. You mention having
trouble on win98 clients.
We will be nothing but Major part XP SP1/SP2 and Windows 2000. I assume you
don't have the same issues on XP and 2000 with the lower level excel
classes.
Thanks in Advance!
-Brandon
-----Original Message-----
From: Matt Benic [mailto:[EMAIL PROTECTED]
Sent: Tuesday, March 29, 2005 9:07 AM
To: development-axapta@yahoogroups.com
Subject: RE: [development-axapta] Open a excelfile
Just a word of warning on using the low level Excel classes (especially to
generate reports), we have had no end of trouble on win98 client machines
using those components. If you can, rather go for a standard report and save
it to excel by setting the file type to html, and specifying a .xls
filename.
Regards,
Matt Benic
Axapta and .Net Developer
UTi Sun Couriers Division
"The universal aptitude for ineptitude
makes any human accomplishment an incredible miracle."
- Col. John P. Stapp
www.smallfrymobile.com <http://www.smallfrymobile.com>
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]
Sent: 29 March 2005 02:46 PM
To: development-axapta@yahoogroups.com
Subject: AW: [development-axapta] Open a excelfile
HI,
use SysExcelWorkbooks Open to open an existing file. Workbooks add will
always add a new workbook to the existing instance of excel.
Mit freundlichen Grüßen / Best regards / Med venlig hilsen
Jesper Jørgensen
NMS - Entwicklung Axapta
arvato systems Technologies GmbH
An der Autobahn 18
33311 Gütersloh
http://www.arvato-systems.de <BLOCKED::http://www.arvato-systems.de/>
E-Mail: [EMAIL PROTECTED]
Phone: 05242 / 40 80 54
Fax: 05242 / 40 80 40
Mobile: 0172 / 571 03 34
____________________________________________________________________________
________________
"Der Inhalt dieser Nachricht oder eventueller Anlagen ist vertraulich und
ausschließlich für den bezeichneten Adressaten bestimmt. Bitte stellen Sie
sicher, dass die Information in dieser Nachricht ausschließlich an die
adressierten Personen gelangt. Sollte diese Nachricht versehentlich an Sie
gesendet worden sein, dann informieren Sie bitte umgehend den Absender und
löschen Sie die Nachricht. Vielen Dank."
"The information in this e-mail and any attachments is confidential. The
information must only be held in areas that have controlled and limited
access to the addressed persons. If this e-mail has been sent to you in
error, please immediately notify the sender and delete the e-mail. Thanks."
_____
Von: anettemalmberg [mailto:[EMAIL PROTECTED]
Gesendet: Dienstag, 29. März 2005 13:48
An: development-axapta@yahoogroups.com
Betreff: [development-axapta] Open a excelfile
Hi,
I try to open an excel-document from a table ProdRoute via menuItem
(Display) atached to a form but I've only got a copy of the Excelfile and
not the original file. I think the reason for that is
codestring >>> sysExcelWorkbook = sysExcelWorkbooks.add
(COMVariant);<<<<, but I am not sure.
This is my init() method on a form
void init()
{
Args callerArgs;
ProdRoute ProdRoute;
FileNameOpen File2Display;
COMVariant COMVariant;
SysExcelApplication sysExcelApplication;
SysExcelWorkbooks sysExcelWorkbooks;
SysExcelWorkbook sysExcelWorkbook;
SysExcelWorksheet sysExcelWorksheet;
super();
COMVariant = new COMVariant();
if (element.args())
{
callerArgs = element.args();
if (callerArgs.dataset() == tablenum(ProdRoute))
{
ProdRoute = callerArgs.record();
File2Display = ProdRoute.File2display();
}
}
sysExcelApplication = SysExcelApplication::construct();
sysExcelApplication.visible(true);
sysExcelWorkbooks = sysExcelApplication.workbooks();
COMVariant.bStr(File2Display);
sysExcelWorkbook = sysExcelWorkbooks.add(COMVariant);
sysExcelWorkbook.saved(true);
element.close();
}
}
Thanks!
Yahoo! Groups Sponsor
ADVERTISEMENT
<http://us.ard.yahoo.com/SIG=129a8epd8/M=298184.6018725.7038619.3001176/D=gr
oups/S=1705006764:HM/EXP=1112183554/A=2593423/R=0/SIG=11el9gslf/*http:/www.n
etflix.com/Default?mqso=60190075> click here
<http://us.adserver.yahoo.com/l?M=298184.6018725.7038619.3001176/D=groups/S=
:HM/A=2593423/rand=791956484>
_____
Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
* To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>
* Your use of Yahoo! Groups is subject to the Yahoo!
<http://docs.yahoo.com/info/terms/> Terms of Service.
[Non-text portions of this message have been removed]
Yahoo! Groups Links
Yahoo! Groups Links
Yahoo! Groups Links
| Yahoo! Groups Sponsor | |
|
|
Yahoo! Groups Links
- To visit your group on the web, go to:
http://groups.yahoo.com/group/development-axapta/
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
