Exporting large MEMO to SLK and opening it

[rdfreedman BellSouth]

Excel export... The format (.slk) saves only the values and formulas on the active worksheet, and has limited cell formatting. Only up to 255 characters are saved per cell. Microsoft does not publish a SYLK (.SLK) specification. 

I seem to remember Excel's .SLK import makes two passes, one) to count rows to reserve and two) to actually do the import... Seems the error is occurring on the first pass since data was not imported. 

Excel cells can contain 32,767 characters since Excel 2007. 

Specifications and limits for Excel 2016-2013. Excel 2010, Excel 2007 

https://support.office.com/en-us/article/Excel-specifications-and-limits-1672b34d-7043-467e-8e27-269d656771c3?CorrelationId=a8d6c8f7-6047-42de-935a-5a408c46c54e&ui=en-US&rs=en-US&ad=US&ocmsassetID=HP010342495#ID0EBABAAA=Excel_2016-2013 

Importing .SLK files... .SLK files are limited to ASCI characters... Some characters cause import problems such as the semicolon. More info and details are here: 

https://en.wikipedia.org/wiki/SYmbolic_LinK_(SYLK) 

Excel's importing routine may not like the contents of a .SLK file or the .SLK file may not be 'clean' or exceeds a 255 character .SLK cell limit.

Reggie Freedman
CPI of South Florida, Inc.
386-960-7073

 
----- Original Message -----
From: Mike Fedkiw via Filepro-list <filepro-list at lists.celestial.com>
Reply-To: Mike Fedkiw <mfedkiwfp at gmail.com>
To: 0 Filepro List <filepro-list at lists.celestial.com>
Sent: 8/17/2017 3:44:00 PM
Subject: Exporting large MEMO to SLK and opening it
________________________________________________________________________________

I really appreciate all the reply's and help I've gotten here, I don't 
think I'd have found a suitable solution without it.

Now that I have a solution to my problems exporting a MEMO to a SLK 
file, I figured I'd post what I'm doing in case It might help someone 
else out in the future.

1.  This worked to export the data export multi 
invfile=c:\!Output\eBay\eBayInvy.slk

2.  This worked to copy the MEMO data invfile(46)=""{invy(367)

The above worked to export the data all along but it took me a while to 
realize it because of the errors I was seeing when trying to open the 
exported SLK file. Then after playing around a bit and doing a little 
more testing and some google searches I found out that Microsoft Excel 
will only open SLK files with 255 characters or less in a cell without 
errors. After knowing the limitations of excel I started looking around 
for a different program to open, edit, etc the SLK files and I found a 
very nice solution with "SoftMaker Office 2016 for Windows" for only 
about 50.00.

I just figured I'd post this information because even if someone knows 
how to export a MEMO to a SLK file, if it happens to be larger than 255 
characters they may not know the limitations of opening that file with 
MS Excel.


Mike




-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170817/07fed546/attachment.html>
_______________________________________________
Filepro-list mailing list
Filepro-list at lists.celestial.com
Subscribe/Unsubscribe/Subscription Changes
http://mailman.celestial.com/mailman/listinfo/filepro-list