HTML as XLSX (Re: Export to Excel)

[Jose Lerebours]

Many moons ago, I had a client that wanted a nice colored 
fonts/background, bold, etc. excel document.

I got it done by exporting an HTML document with CSS properties and all 
but instead of naming it .html I named it .xls

Excel did a great job at displaying the tables and layers with all 
properties; I wonder if this trick can be an easy solution for your needs!?!

Mind you, this was many moons ago, current version is XML based (I 
think) and I am not sure if it will like this at all but may be worth a try.



On 08/27/2018 02:42 PM, Richard D. Williams via Filepro-list wrote:
> If you are making a .csv file, I think you should try a carriage, 
> chr("14").
>
> i.e.
> la="12345"
> ha="Desc1 text"
> hb="Desc2 text"
> hc="Desc3 text"
> lc="1234.33"
>
> lb=ha&chr("14")&hb&chr("14")&hc
>
> mgr(1)=la;mgr(2)=lb;mgr(3)=lc
>
> If ha, hb, or lc is blank you should conditionalize the creation of lb.
>
> Richard D. Williams
>
> On 8/26/2018 5:16 PM, Scott Walker via Filepro-list wrote:
>> When I do an export to excel what do I need to insert in the data 
>> stream to
>> get excel to do jump to a new line in the current cell.
>>
>> In my filepro file I have desc1 and desc2 and desc3 as separate fields.
>>
>> In Excel I want to end up with them all in one cell but each one on a 
>> line
>> by itself like:
>>
>> Part#    Description    List Price
>>
>> 12345    Desc1 text    1234.33
>>     Desc2 text
>>     Desc3 text
>>
>>
>>
>> Regards,
>> Scott Walker
>>
>>
>>
>> _______________________________________________
>> Filepro-list mailing list
>> Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes
>> http://mailman.celestial.com/mailman/listinfo/filepro-list
>>
>>
>>
>>
>> ---
>> This email has been checked for viruses by AVG.
>> https://www.avg.com
>>
>>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list