My assumption is that amit will be using the spreadsheet as the source of data and process them. We still do this with our system but we were trying to wean the user from using excel as their local database so we made an import module using C# which basically reads the excel file and write it to an MS-SQL database. Then J is just given the dataset to process.
I've seen excel files used as an inventory system and the largest excel file they have is only around 8MB (maybe less) and that one is already considered as HUGE. I would suggest to amit to actually test J with Excel by playing with the largest file that he can put his hand one. ;) -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sherlock, Ric Sent: Monday, April 21, 2008 12:06 PM To: Programming forum Subject: RE: [Jprogramming] J performance with large excel spreadsheets. ---amit bolakani wrote: > I was considering using J for building a commercial > application which would > need to handle huge excel spread sheets on Windows systems with good > performance. Does J handle this well? I would believe that > one would need to > use memory mapped files for this. Are memory mapped files > functionality > developed well enough with J for me to consider it as my > language of choice > for this project? I think that you will get more helpful answers if you explain a bit more what you mean by "handle huge excel spread sheets". What do you want to do with them (or the information on them)? ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm ---------------------------------------------------------------------- For information about J forums see http://www.jsoftware.com/forums.htm
