Bill, this looks fantastic! I am going to try to integrate it into my excel reporting tool today and see how it works. Once I get the tool to a point where it is cleaner than it is now I want to be able to share it here. -Ed
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of bill lam Sent: Wednesday, October 06, 2010 11:57 PM To: [email protected] Subject: Re: [Jbeta] wdooo was Re: Write array to Excel via OLE Automation without using Paste? wdooo now supports safearray, please upgrade from pacman. There are some issues, 1. 64-bit oleautomation does not accept safearray of variant, but my testing environment is limited. Please confirm if that actually works using 64-bit excel or using c# 2. openoffice part is currently broken. Втр, 05 Окт 2010, Cox, Ed писал(а): > Whatever you can accomplish would be appreciated greatly! > > One issue I foresee that I should state with regard to passing a boxed array > is that boxed arrays of strings tend to have trailing blanks in the cells > when the contents of the actual text differs within a column. The original > xlutil and clipfmt approach tended to keep these trailing blanks. I had to > alter the design so that my data was in a level 2 boxed array with each cell > trimmed of trailing blanks, and then my version of clipfmt maintained that as > it built the tab delimited string. This would be important I think for > implementing the variant/safearray you mentioned. This is important in cases > like mine where the data come from SQL queries and the data types are > varchar, so anything that adds or keeps trailing blanks would not be true to > the original data. > > Ed Cox > Principal Data Analyst > MedMined(tm) > > > _________________________________________________ > > This message is for the designated recipient only and may contain privileged, > proprietary > or otherwise private information. If you have received it in error, please > notify the sender > immediately and delete the original. Any other use of the email by you is > prohibited. > > Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - > Norsk - Portuguese > Svenska: www.carefusion.com/legal/email > ---------------------------------------------------------------------- > For information about J forums see http://www.jsoftware.com/forums.htm -- regards, ==================================================== GPG key 1024D/4434BAB3 2008-08-24 gpg --keyserver subkeys.pgp.net --recv-keys 4434BAB3 ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm _________________________________________________ This message is for the designated recipient only and may contain privileged, proprietary or otherwise private information. If you have received it in error, please notify the sender immediately and delete the original. Any other use of the email by you is prohibited. Dansk - Deutsch - Espanol - Francais - Italiano - Japanese - Nederlands - Norsk - Portuguese Svenska: www.carefusion.com/legal/email ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
