Welcome Guest! To enable all features please Login. New Registrations are disabled.

Notification

Icon
Error

Login


10 Pages<1234>»
Options
Go to last post Go to first unread
Offline kilele  
#21 Posted : 19 December 2012 20:16:54(UTC)
kilele


Rank: Advanced Member

Groups: Registered
Joined: 30/03/2011(UTC)
Posts: 393

Was thanked: 132 time(s) in 113 post(s)
Please look at these resources, I assume they support writing excel files with .Net2

http://npoi.codeplex.com/

http://www.codeproject.c...ML-Import-Export-Library

you may also want to ask on the 'Excel Data Reader' forum about some 'Excel Data writer' with the same compatibility as their project.

Edit:

NPOI Tutorial at
http://www.leniel.net/20...adsheets-xls-xlsx-c.html

Edited by user 19 December 2012 20:56:25(UTC)  | Reason: Not specified

Offline Davide Carpi  
#22 Posted : 12 January 2013 17:49:58(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
PLUGIN UPDATED


added exportData.ODF to export data to OpenFormula files.


[edit] when possible, the default output is: formula as defined = symbolical formula (variables replaced with numbers) = numerical output value

direct assignment: data to export written inside exportData.ODF 1st argument.


best regards,

w3b5urf3r

Edited by user 12 January 2013 18:37:45(UTC)  | Reason: Not specified

Davide Carpi attached the following image(s):
my SMath ODF output.odf - LOdev Math.png
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
thanks 2 users thanked Davide Carpi for this useful post.
on 12/01/2013(UTC),  on 13/01/2013(UTC)
Offline mkraska  
#23 Posted : 13 January 2013 04:10:40(UTC)
mkraska


Rank: Advanced Member

Groups: Registered
Joined: 15/04/2012(UTC)
Posts: 1,980
Germany

Was thanked: 1120 time(s) in 718 post(s)
Hello w3bsurf3r,

thank you for the math export function. It made me download and install OpenOffice (I normally use LyX/Latex or MS Office).

I would propose to stick to standard notation in export functions, which would mean:
  • quantity symbols are typeset in italic (this is currently done correctly)
  • unit symbols are typeset in roman (by adding "nitalic" or marking as text by quotation marks)
  • Number and unit are separated by a (small) space (replacing cdot by ` in front of units)


Perhaps a context menu option to copy the region to clipboard in odf or latex notation could be a nice feature. But of course, I have no idea if and with what effort this can be done.

Martin

Martin Kraska

Pre-configured portable distribution of SMath Studio: https://smath.com/wiki/SMath_with_Plugins.ashx
Offline Davide Carpi  
#24 Posted : 13 January 2013 12:57:56(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: mkraska Go to Quoted Post
Hello w3bsurf3r,

thank you for the math export function. It made me download and install OpenOffice (I normally use LyX/Latex or MS Office).

I would propose to stick to standard notation in export functions, which would mean:
  • quantity symbols are typeset in italic (this is currently done correctly)
  • unit symbols are typeset in roman (by adding "nitalic" or marking as text by quotation marks)
  • Number and unit are separated by a (small) space (replacing cdot by ` in front of units)

Hi Martin,

I think it's a good standardization, I'll do it in the next relase Good

Originally Posted by: mkraska Go to Quoted Post
Perhaps a context menu option to copy the region to clipboard in odf or latex notation could be a nice feature. But of course, I have no idea if and with what effort this can be done.

Martin

I don't know how to do it, but I'm working to save the entire sheet as an ODT document Wink


best regards,

w3b5urf3r

Edited by user 13 January 2013 12:59:40(UTC)  | Reason: Not specified

If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline Infinity  
#25 Posted : 14 January 2013 11:50:02(UTC)
Infinity


Rank: Member

Groups: Registered
Joined: 19/01/2012(UTC)
Posts: 12
Man

Was thanked: 3 time(s) in 2 post(s)
Originally Posted by: w3b5urf3r_reloaded Go to Quoted Post
I think this can be better http://closedxml.codeplex.com/ but works with .NET framework 4.0...


The same DLL is also available for .NET framework 3.5.
I already worked with the closedxml plugin in SMath and it works very well with .NET 3.5.

When I find time, I will bring the features of closedxml to SMath.


Infinity
Offline Davide Carpi  
#26 Posted : 14 January 2013 13:13:57(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: Infinity Go to Quoted Post
Originally Posted by: w3b5urf3r_reloaded Go to Quoted Post
I think this can be better http://closedxml.codeplex.com/ but works with .NET framework 4.0...


The same DLL is also available for .NET framework 3.5.
I already worked with the closedxml plugin in SMath and it works very well with .NET 3.5.

When I find time, I will bring the features of closedxml to SMath.

Infinity

You are right, .NET 3.5 works without problems (f.e. I've seen that the DocxFileType plugin works under .NET 3.5 and does not cause issues) Good

Obviously now an *.xlsx import/export feature could be added Wink

[edit] exportData.XLSX and importData.XLSX fully implemented Biggrin

Edited by user 14 January 2013 20:10:07(UTC)  | Reason: Not specified

If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
thanks 1 user thanked Davide Carpi for this useful post.
on 14/01/2013(UTC)
Offline kilele  
#27 Posted : 14 January 2013 18:31:21(UTC)
kilele


Rank: Advanced Member

Groups: Registered
Joined: 30/03/2011(UTC)
Posts: 393

Was thanked: 132 time(s) in 113 post(s)
Bravissimo!!!
Offline Davide Carpi  
#28 Posted : 17 January 2013 13:22:00(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
PLUGIN UPDATED

REQUIREMENTS: .NET Framework required version upgraded to 3.5

  • added "Save as" odt files:
    - editable equations;
    - text formatting like SMath worksheet (size, colors, style:bold/italic/underline);
    - page size & orientation like SMath worksheet.
  • added exportData.XLSX and importData.XLSX
  • ODF formulas:
    - added: el(3), range(2), range(3), sys(), all trigonometric functions, subscripts, absolute variables (~variable), empty values (#), nested quotes.
    - units: typeset, multiplication symbol;
    - text: added quotes, alignments inside matrices;
    - programming: added line()*, if/else, for(3), for(4), while();
    - booleans: fixed comparision symbols issues;
    - general: fixed conflicts with reserved words and symbols, output markup adjustements.
  • dynamic assistance adapted to multilanguage (ENG/ITA implemented, send me a PM with your translations to have more languages)
  • exportData.CSV and exportData.ODS enhanced to export even unassigned variables.

* when there is a variable/function defined with a line(), the right side could be higher than the left side; simply add some #{} after the = sign to pull up the left side.


best regards,

w3b5urf3r

Edited by user 17 January 2013 14:28:06(UTC)  | Reason: Not specified

Davide Carpi attached the following image(s):
PolyProperties_2012.01.00[RC6].odt - LibreOffice Writer.png
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
thanks 2 users thanked Davide Carpi for this useful post.
on 17/01/2013(UTC),  on 19/01/2013(UTC)
Offline PompelmoTell  
#29 Posted : 17 January 2013 17:04:45(UTC)
PompelmoTell


Rank: Advanced Member

Groups: Registered
Joined: 23/12/2011(UTC)
Posts: 318
Man
Italy
Location: italy

Was thanked: 109 time(s) in 93 post(s)
I find a problem in loading the plugin
I doubt that it is the absence of the framrwork 3.5
The framework version 4 is not suitable?

smath 0.95 build 4594 30/07/2012
win7
microsoft.net framework 4

grazie
sergio
Offline Davide Carpi  
#30 Posted : 17 January 2013 17:29:31(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: PompelmoTell Go to Quoted Post
I find a problem in loading the plugin
I doubt that it is the absence of the framrwork 3.5
The framework version 4 is not suitable?

smath 0.95 build 4594 30/07/2012
win7
microsoft.net framework 4

grazie
sergio


Hi, I think not (at least doesn't work for me); I attach here a .NET 4 DataExchange.dll but in my PC this cause that SMath disable the plugin. If you can install the framework, here there is the .NET framework 3.5 from Microsoft website (no registration required). If you can't I can add a .NET 2.0 plugin without XLSX support.

---
Ciao, non credo o almeno a me non funziona... ti allego la versione compilata per .NET framework 4 ma a me disabilita la plugin all'avvio. Comunque se hai la possibilità di installarlo il framework lo puoi trovare nel sito Microsoft senza registrazione .NET framework 3.5. Se non puoi, posso comunque aggiungere ai download una plugin "ristretta" senza il support ai file XLSX per .NET framework 2.0.

Edited by user 17 January 2013 17:32:54(UTC)  | Reason: Not specified

File Attachment(s):
DataExchange.zip (26kb) downloaded 54 time(s).
Davide Carpi attached the following image(s):
PrtScr capture.png
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline PompelmoTell  
#31 Posted : 17 January 2013 19:15:11(UTC)
PompelmoTell


Rank: Advanced Member

Groups: Registered
Joined: 23/12/2011(UTC)
Posts: 318
Man
Italy
Location: italy

Was thanked: 109 time(s) in 93 post(s)
Come hai capito ho qualche problema con l'inglese.
- comunque ti confermo che la versione compilata col framework 4 non funziona.
- al momento avendo letto sui forum la non opportunità di installare la framework 3.5 su sistemi win7 che hanno già la 4 ho preferito fare un downgrade alla versione precedente del plugin
comunque grazie per gli ottimi lavori che hai fatto fino ad ora.

However you can confirm that the version compiled with framework 4 does not work.
At the moment i have preferred to make a downgrade to a previous version of the plugin.
Thank You for the excellent work that you've done up to now

sergio
Offline Davide Carpi  
#32 Posted : 17 January 2013 21:05:32(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: PompelmoTell Go to Quoted Post
Come hai capito ho qualche problema con l'inglese.
- comunque ti confermo che la versione compilata col framework 4 non funziona.
- al momento avendo letto sui forum la non opportunità di installare la framework 3.5 su sistemi win7 che hanno già la 4 ho preferito fare un downgrade alla versione precedente del plugin
comunque grazie per gli ottimi lavori che hai fatto fino ad ora.

However you can confirm that the version compiled with framework 4 does not work.
At the moment i have preferred to make a downgrade to a previous version of the plugin.
Thank You for the excellent work that you've done up to now

sergio


Seeking to understand the problem, I saw that .NET framework 3.5 it's an upgrade of 2.0 version and .Net framework 4 it's a completely new framework; all can be installed on the same system (but version 3.5 doesn't work without 2.0) and at least in theory any windows 7 system contains a built-in .NET framework 3.5... Maybe my first idea could be wrong, so could you make a screenshot of the issue?

However I've uploaded in the first post an updated version of DataExchange plugin, without XLSX functions, for .NET 2.0 systems.

---
Ho guardato un pò in giro cercando di capire quale possa essere il problema... Il framework 3.5 è un'estensione del 2.0 mentre il 4 è una cosa completamente nuova ed indipendente; tutti e tre possono essere installati sullo stesso computer (ma il 3.5 non funziona senza il 2) e, almeno in teoria, windows 7 ha il 3.5 nativo essendo basato su di esso (e per questo non lo si trova in installazione/applicazioni). Quindi potrebbe anche essere che la mia "diagnosi" sia sbagliata.. potresti fare una copia del messaggio di errore (con la plugin 3.5 ovviamente)?

Ad ogni modo nel primo post ho aggiunto un link alla plugin aggiornata basata sul framework 2.0; è più leggera ma ovviamente non supporta lo scambio dati con i files XLSX.

Ciao!
---


best regards,

w3b5urf3r

Edited by user 17 January 2013 22:34:54(UTC)  | Reason: Not specified

If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline kilele  
#33 Posted : 18 January 2013 03:00:29(UTC)
kilele


Rank: Advanced Member

Groups: Registered
Joined: 30/03/2011(UTC)
Posts: 393

Was thanked: 132 time(s) in 113 post(s)
@Sergio
If I've understood right, you have win7 with .NET 4 which should be compatible when running the plugin compiled for .NET 3.5
You might want to run windows update to download a newer .NET framework version.
Maybe .NET 4.5 (not compatible with xp) works better with the other .NET frameworks installed on your computer. You can donwload it at
http://www.microsoft.com...ad/details.aspx?id=30653
On a side note, you can run this other software to clarify which .NET versions you have already installed
http://portableapps.com/...dotnetinspector-portable

Edited by user 18 January 2013 03:14:56(UTC)  | Reason: Not specified

thanks 1 user thanked kilele for this useful post.
on 18/01/2013(UTC)
Offline mkraska  
#34 Posted : 18 January 2013 18:50:20(UTC)
mkraska


Rank: Advanced Member

Groups: Registered
Joined: 15/04/2012(UTC)
Posts: 1,980
Germany

Was thanked: 1120 time(s) in 718 post(s)
Hello W3bsurf3r
thank you for the odt-export feature, great work! It works really fine and I like the formatting. I observed the following issues:

- Images (from image or plot regions) are shrunk to a small thumbnail when loading exported odt files. The images seem to have the correct resolution and size information, but some odd scaling factors are applied. Once they are reset to 100%, you get the correct size and aspect ratio of the images.

- Word 2010 can read odt files directly. However, it fails to read the files exported by your plugin. Once I read the odt into Libre- or OpenOffice Writer and save it again as odt, then Word can read the file (one has to ignore the annoying complaints about damaged contents). May be, by adjusting the odt format the plugin could gain direct Word connectivity.

How about bringing the Latex-Plugin by Andrey to the Level reached by your odt export?

Martin

Martin Kraska

Pre-configured portable distribution of SMath Studio: https://smath.com/wiki/SMath_with_Plugins.ashx
thanks 1 user thanked mkraska for this useful post.
on 18/01/2013(UTC)
Offline PompelmoTell  
#35 Posted : 18 January 2013 18:51:57(UTC)
PompelmoTell


Rank: Advanced Member

Groups: Registered
Joined: 23/12/2011(UTC)
Posts: 318
Man
Italy
Location: italy

Was thanked: 109 time(s) in 93 post(s)
Thanks kilele and w3b5urf3r,
The version of DataExchange plugin, without XLSX functions, for .NET 2.0 systems, works correctly.

sergio
Offline Davide Carpi  
#36 Posted : 18 January 2013 19:43:15(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: mkraska Go to Quoted Post
Hello W3bsurf3r
thank you for the odt-export feature, great work! It works really fine and I like the formatting. I observed the following issues:

- Images (from image or plot regions) are shrunk to a small thumbnail when loading exported odt files. The images seem to have the correct resolution and size information, but some odd scaling factors are applied. Once they are reset to 100%, you get the correct size and aspect ratio of the images.

- Word 2010 can read odt files directly. However, it fails to read the files exported by your plugin. Once I read the odt into Libre- or OpenOffice Writer and save it again as odt, then Word can read the file (one has to ignore the annoying complaints about damaged contents). May be, by adjusting the odt format the plugin could gain direct Word connectivity.

How about bringing the Latex-Plugin by Andrey to the Level reached by your odt export?

Martin



Hi Martin,

thank you for your feedbacks Thank you

Using LibreOffice 3.6 and 4.0 on my system I can't see the image size issues... could you attach a plugin-saved odt and odf and the re-saved files from your office application?

The Latex-Plugin it's the root of *.odf and *.odt features of DataExchange plugin, so update the plugin with new enhancements it's not a big issue; unfortunately my latex is very basic, so probably it will take some time Umnik


regards,

w3b5urf3r

Edited by user 18 January 2013 20:09:43(UTC)  | Reason: Not specified

If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline mkraska  
#37 Posted : 19 January 2013 03:45:09(UTC)
mkraska


Rank: Advanced Member

Groups: Registered
Joined: 15/04/2012(UTC)
Posts: 1,980
Germany

Was thanked: 1120 time(s) in 718 post(s)
Hello w3bsurf3r,

I tried with LibreOffice 3.6

Here are the example files for the image size problem

Zugstab_export.odt is as exported by SMath,
Zugstab_export_LO.odt is as saved by LibreOffice Writer.

I had to zip the files because odt attachments are not allowed in the forum.

Martin

Edited by user 19 January 2013 03:53:02(UTC)  | Reason: Not specified

File Attachment(s):
Zugstab.sm (27kb) downloaded 47 time(s).
Konischer Zugstab.zip (77kb) downloaded 48 time(s).
mkraska attached the following image(s):
exportodt.PNG
Martin Kraska

Pre-configured portable distribution of SMath Studio: https://smath.com/wiki/SMath_with_Plugins.ashx
Offline Davide Carpi  
#38 Posted : 19 January 2013 05:23:18(UTC)
Davide Carpi


Rank: Advanced Member

Groups: Registered, Advanced Member
Joined: 13/01/2012(UTC)
Posts: 2,639
Man
Italy
Location: Italy

Was thanked: 1323 time(s) in 873 post(s)
Originally Posted by: mkraska Go to Quoted Post
Hello w3bsurf3r,

I tried with LibreOffice 3.6

Here are the example files for the image size problem

Zugstab_export.odt is as exported by SMath,
Zugstab_export_LO.odt is as saved by LibreOffice Writer.

I had to zip the files because odt attachments are not allowed in the forum.

Martin


Try the attached DataExchange.dll

File Attachment(s):
DataExchange.zip (26kb) downloaded 58 time(s).
If you like my plugins consider to support SMath Studio buying a plan; to offer me a coffee: paypal.me/dcprojects
Offline kilele  
#39 Posted : 19 January 2013 13:20:26(UTC)
kilele


Rank: Advanced Member

Groups: Registered
Joined: 30/03/2011(UTC)
Posts: 393

Was thanked: 132 time(s) in 113 post(s)
@w3bsurf3r
regarding what Martin told about Word 2010 opening odt files,
if you don't have Office 2010 ready at hand you may want to try Skydrive, the web app of Microsoft.
Offline mkraska  
#40 Posted : 19 January 2013 14:07:59(UTC)
mkraska


Rank: Advanced Member

Groups: Registered
Joined: 15/04/2012(UTC)
Posts: 1,980
Germany

Was thanked: 1120 time(s) in 718 post(s)
Originally Posted by: w3b5urf3r_reloaded Go to Quoted Post

Try the attached DataExchange.dll


images now have the correct size, thank you for the bug fix. Also, direct word read in is possible (zugstab-export-1.odt). However, in this case only images and text regions are read, all math regions (formulas) are broken.

Intermediate load and save with libreoffice (zugstab-export-LO-1.odt) improves the word import, still the formatting of control structures is broken.

In general, opening both odt files with word generates error messages. If saved as docx from Libreoffice, then Word can read the file cleanly, still formatting is broken (mainly due to centering of math items)

Martin

File Attachment(s):
Konischer Zugstab.rar (50kb) downloaded 64 time(s).
mkraska attached the following image(s):
zugstab-lo.PNG
zugstab-word.PNG
Martin Kraska

Pre-configured portable distribution of SMath Studio: https://smath.com/wiki/SMath_with_Plugins.ashx
Users browsing this topic
Similar Topics
[Data Exchange Plugin] Export data (more than 4 columns) (Questions)
by chandragon 29/03/2017 12:08:24(UTC)
10 Pages<1234>»
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.