My problem doesnt seem to be due to the code, but due to the size of my spreadsheet. I am now working on finding the maximum number of rows that Maple can take on my computer so that I can spit the files. Thanks

My problem doesnt seem to be due to the code, but due to the size of my spreadsheet. I am now working on finding the maximum number of rows that Maple can take on my computer so that I can spit the files. Thanks

@longrob 

I've cut down the number of columns to 255 and it worked, 256 columns showed the error message. This rule was probably implemented before Office 2007 was released and not updated since then. Have a look at these links

Excel 2003 :http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Excel 2010 : http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

@longrob 

I've cut down the number of columns to 255 and it worked, 256 columns showed the error message. This rule was probably implemented before Office 2007 was released and not updated since then. Have a look at these links

Excel 2003 :http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP005199291.aspx

Excel 2010 : http://office.microsoft.com/en-us/excel-help/excel-specifications-and-limits-HP010342495.aspx?CTT=5&origin=HP005199291

@longrob 

Ah ok, I was thinking 255 was the limit imposed for the export matrix.  This is not ideal though since excel allows 16 000+ columns as from Excel 2007 ( it was 255 in earlier versions) . This is definitely something that the developpers at maplesoft should consider.

@longrob 

Ah ok, I was thinking 255 was the limit imposed for the export matrix.  This is not ideal though since excel allows 16 000+ columns as from Excel 2007 ( it was 255 in earlier versions) . This is definitely something that the developpers at maplesoft should consider.

@longrob 

The sprintf seems to work fine. If, for example, I ask for only M and L to be exported, maple happily executes the code and names the files correctly. But if I try to export MM or LL , then I get "Error,(in ExcelTools:-Export) Export failed.  Verify that the exported table does not contain more than 255 columns and 65535 rows."

Now the reason why I have created LL and MM, in the first place, was to make sure that I was not exporting more than 255 columns but this is the error that I am getting. Do you think this could be because LL and MM are being exported to column GL on the spreadsheet?   

@longrob 

The sprintf seems to work fine. If, for example, I ask for only M and L to be exported, maple happily executes the code and names the files correctly. But if I try to export MM or LL , then I get "Error,(in ExcelTools:-Export) Export failed.  Verify that the exported table does not contain more than 255 columns and 65535 rows."

Now the reason why I have created LL and MM, in the first place, was to make sure that I was not exporting more than 255 columns but this is the error that I am getting. Do you think this could be because LL and MM are being exported to column GL on the spreadsheet?   

Hello longrob, I have taken this code apart and have put it back together but couldnt solve the problem or spot this error. Thanks a lot!  now on to the next problems.. doesnt want to export :S.

Lovinash

Hello longrob, I have taken this code apart and have put it back together but couldnt solve the problem or spot this error. Thanks a lot!  now on to the next problems.. doesnt want to export :S.

Lovinash

Hello Markiyan, thanks for answering. do you know how to use <= on 1d input? In my case, they are all part of IF statements.

Hello Markiyan, thanks for answering. do you know how to use <= on 1d input? In my case, they are all part of IF statements.

Hello Pagan,

First of all thanks a lot, your solutions works. As you said, the program isnt very efficient and that is because I dont know yet how to make it any more efficient :D  . I'm very new to maple and programming in general but I'm slowly getting there

Thanks again

Lovi

Hello Pagan,

First of all thanks a lot, your solutions works. As you said, the program isnt very efficient and that is because I dont know yet how to make it any more efficient :D  . I'm very new to maple and programming in general but I'm slowly getting there

Thanks again

Lovi

and it was silly a mistake. my bad.

Thanks for answering

Lovi