I have been creating a CSV file and opening it with Excel while testing the results of my work with XML and BMP
I saw your messages about grid and excel and decided to see if I could change into grid a=.fread DCM_SAFN_ first element in the top row is not there so the file starts with a ";" ";AcquisitionDate;AcquisitionTime;Ins......." So I add some text in front and then call grid a=.'hallo',a b=. chop a c=. ';'chop each b grid >c Looks pretty nice Starts much faster than Excel too 2007/3/12, Anssi Seppälä <[EMAIL PROTECTED]>:
J grid shows 2000000 rows or 2000000 columns and more. Just tested. Anssi At 20:18 12.3.2007, you wrote: >From: > http://office.microsoft.com/en-us/excel/HA101656321033.aspx?pid=CL100571521033 > > > >Enjoy increased spreadsheet row and column capacity of 1 million rows by >16,000 columns that enables you to import and work with massive amounts of >data and achieve faster calculation performance with support for dual or >multicore processors. > > > > >Paul Gauthier >APL Software Developer - Senior >[EMAIL PROTECTED] >Phone: 312-739-3467 >Fax: 312-739-3496 > >CheckFree. The Company that Powers Payment on the WebSM. >http://www.checkfree.com/paybillsonline > > > > >Anssi Seppälä <[EMAIL PROTECTED]> >Sent by: [EMAIL PROTECTED] >03/12/2007 12:44 PM >Please respond to >General forum <[email protected]> > > >To >General forum <[email protected]> >cc > >Subject >[Jgeneral] The J6 grid better than Excel > > > > > > >Just found that there is no limit on number of columns in J grid >while in Excel it is 256. Great thing! >Thanks, Anssi > >---------------------------------------------------------------------- >For information about J forums see http://www.jsoftware.com/forums.htm > >---------------------------------------------------------------------- >For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
-- Björn Helgason, Verkfræðingur Fugl&Fiskur ehf, Þerneyjarsund 23, Box 127 801 Grímsnes ,t-póst: [EMAIL PROTECTED] Skype: gosiminn, gsm: +3546985532 Landslags og skrúðgarðagerð, gröfuþjónusta http://groups.google.com/group/J-Programming Tæknikunnátta höndlar hið flókna, sköpunargáfa er meistari einfaldleikans góður kennari getur stigið á tær án þess að glansinn fari af skónum /|_ .-----------------------------------. ,' .\ / | Með léttri lund verður | ,--' _,' | Dagurinn í dag | / / | Enn betri en gærdagurinn | ( -. | `-----------------------------------' | ) | (\_ _/) (`-. '--.) (='.'=) `. )----' (")_(")
---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
