From: Updike, C. <Cla...@jh...> - 2003-12-17 05:22:42
|
If your using wxpython to access excel and want to keep doing that, your only hope might be cyphon, which is probably vaporware: <http://lists.wxwindows.org/archive/wxPython-users/msg09122.html> <http://www.geocrawler.com/archives/3/7017/2002/10/0/10030291/> If you can give up wxpython, I've heard POI is decent. Since it's just java, you can use it from jython. I'm sure there are others: <http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html> Google is your friend... search on: jython excel jython wxpython -Clark -----Original Message----- From: Subbu Sent: Tuesday, December 16, 2003 11:43 PM Subject: [Jython-users] Fw: Connecting Ms Excel Hi, I am currently working onJython and developing a test module for the Java application we have. I would like to connect to Ms Excel and retrieve data from it for further testing. I beleive it is possible because i have done it in Python using win32com.client. Now, how do i do it in Jython... Awaiting reply and thanx in advance Regards & Thanks Subramanian.S (SSB) *: 91 - 44 - 2825 5541 Extn.2023 S R A S Y S T E M S L I MI T E D Start from where you are not from where you want to be. |
From: Cherney John-C. <Joh...@mo...> - 2003-12-17 15:22:33
|
I've had good luck with POI ( http://jakarta.apache.org/poi/index.html <http://jakarta.apache.org/poi/index.html> ). The only problem I had was that it didn't seem to like cells that were linked to cells in another sheet in the workbook. But for everything else, it was fine. jwc -----Original Message----- From: jyt...@li... [mailto:jyt...@li...]On Behalf Of Subbu Sent: Tuesday, December 16, 2003 11:43 PM To: jyt...@li... Subject: [Jython-users] Fw: Connecting Ms Excel Hi, I am currently working onJython and developing a test module for the Java application we have. I would like to connect to Ms Excel and retrieve data from it for further testing. I beleive it is possible because i have done it in Python using win32com.client. Now, how do i do it in Jython... Awaiting reply and thanx in advance Regards & Thanks Subramanian.S (SSB) *: 91 - 44 - 2825 5541 Extn.2023 S R A S Y S T E M S L I MI T E D Start from where you are not from where you want to be. |
From: Sells, F. <fr...@ad...> - 2003-12-29 17:09:51
|
seems to me you can setup an ODBC link to Excel, then use the JDBC-ODBC bridge to get a JDBC connection to ODBC. -----Original Message----- From: Updike, Clark [mailto:Cla...@jh...] Sent: Wednesday, December 17, 2003 12:23 AM To: jyt...@li... Subject: RE: [Jython-users] Fw: Connecting Ms Excel Importance: Low If your using wxpython to access excel and want to keep doing that, your only hope might be cyphon, which is probably vaporware: <http://lists.wxwindows.org/archive/wxPython-users/msg09122.html> <http://www.geocrawler.com/archives/3/7017/2002/10/0/10030291/> If you can give up wxpython, I've heard POI is decent. Since it's just java, you can use it from jython. I'm sure there are others: <http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html> Google is your friend... search on: jython excel jython wxpython -Clark -----Original Message----- From: Subbu Sent: Tuesday, December 16, 2003 11:43 PM Subject: [Jython-users] Fw: Connecting Ms Excel Hi, I am currently working onJython and developing a test module for the Java application we have. I would like to connect to Ms Excel and retrieve data from it for further testing. I beleive it is possible because i have done it in Python using win32com.client. Now, how do i do it in Jython... Awaiting reply and thanx in advance Regards & Thanks Subramanian.S (SSB) *: 91 - 44 - 2825 5541 Extn.2023 S R A S Y S T E M S L I MI T E D Start from where you are not from where you want to be. ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click _______________________________________________ Jython-users mailing list Jyt...@li... https://lists.sourceforge.net/lists/listinfo/jython-users |
From: Updike, C. <Cla...@jh...> - 2003-12-29 17:29:00
|
Good point, since read-only capability is all that is needed. The ODBC interface only supports very limited sql functionality but I think quering data off of a sheet is do-able. I don't know if this document applies to later versions of Excel (article is dated 1999), but it lists some of the limitations at that time: <http://support.microsoft.com/default.aspx?scid=kb;en-us;178717> I believe that with POI you could even read an excel file on non-MS platforms (it works at the binary file level)--if that matters. -Clark -----Original Message----- From: Sells, Fred Sent: Monday, December 29, 2003 12:10 PM To: jyt...@li... Subject: RE: [Jython-users] Fw: Connecting Ms Excel seems to me you can setup an ODBC link to Excel, then use the JDBC-ODBC bridge to get a JDBC connection to ODBC. -----Original Message----- From: Updike, Clark Sent: Wednesday, December 17, 2003 12:23 AM To: jyt...@li... Subject: RE: [Jython-users] Fw: Connecting Ms Excel Importance: Low If your using wxpython to access excel and want to keep doing that, your only hope might be cyphon, which is probably vaporware: <http://lists.wxwindows.org/archive/wxPython-users/msg09122.html> <http://www.geocrawler.com/archives/3/7017/2002/10/0/10030291/> If you can give up wxpython, I've heard POI is decent. Since it's just java, you can use it from jython. I'm sure there are others: <http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html> Google is your friend... search on: jython excel jython wxpython -Clark -----Original Message----- From: Subbu Sent: Tuesday, December 16, 2003 11:43 PM Subject: [Jython-users] Fw: Connecting Ms Excel Hi, I am currently working onJython and developing a test module for the Java application we have. I would like to connect to Ms Excel and retrieve data from it for further testing. I beleive it is possible because i have done it in Python using win32com.client. Now, how do i do it in Jython... Awaiting reply and thanx in advance Regards & Thanks Subramanian.S (SSB) *: 91 - 44 - 2825 5541 Extn.2023 S R A S Y S T E M S L I MI T E D |
From: <dd...@bi...> - 2003-12-29 22:39:43
|
We are migrating our server side java application into UTF-8. All of our web pages and database data are configured to handle UTF-8. What are the necessary steps to configure jython to accept and return UTF-8 characters. In one situation lower case umlaut (ü) returns me this '\xFC'. In command line I test as "CMD>a = 'ü' CMD>a" and I find the value as '\uFFFD'. --Dipankar |
From: <dd...@bi...> - 2003-12-30 21:48:03
|
From java class I call the follwoing line of code. intertpreter.exec(a='ü') Same code works fine on WindowsXP. I cannot run it on Linux. "file.encoding" property for JVM has been set to "UTF-8". On Linux I get the following error. SyntaxError: LexicalError at line 1, column 5. Encountered: <EOF> after: "" --Dipankar ----- Original Message ----- From: "Dipankar Das" <dd...@bi...> To: <jyt...@li...> Sent: Monday, December 29, 2003 2:39 PM Subject: [Jython-users] How to make jython work with UTF-8 > We are migrating our server side java application into UTF-8. > All of our web pages and database data are configured to handle UTF-8. > > What are the necessary steps to configure jython to accept and return UTF-8 > characters. > In one situation lower case umlaut (ü) returns me this '\xFC'. > In command line I test as "CMD>a = 'ü' CMD>a" and I find the value as > '\uFFFD'. > > > --Dipankar > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IBM Linux Tutorials. > Become an expert in LINUX or just sharpen your skills. Sign up for IBM's > Free Linux Tutorials. Learn everything from the bash shell to sys admin. > Click now! http://ads.osdn.com/?ad_id=1278&alloc_id=3371&op=click > _______________________________________________ > Jython-users mailing list > Jyt...@li... > https://lists.sourceforge.net/lists/listinfo/jython-users |
From: Ed K. <ed...@ap...> - 2004-01-02 00:04:32
|
On Tue, Dec 30, 2003 at 01:47:55PM -0800, Dipankar Das wrote: > >From java class I call the follwoing line of code. > intertpreter.exec(a=3D'=C3=BC') >=20 > Same code works fine on WindowsXP. I cannot run it on Linux. "file.enco= ding" > property for JVM has been set to "UTF-8". On Linux I get the following > error. >=20 > SyntaxError: LexicalError at line 1, column 5. Encountered: <EOF> after= : "" [snip] > > What are the necessary steps to configure jython to accept and return > UTF-8 > > characters. [snip] I haven't done I18N work in Jython, except with libraries that were already doing the conversion. Jython certainly handles unicode data fine if other code has done the conversion from UTF-8 to the internal unicode representation (in Java, it's a UTF-16 variant). And Java has a number of idioms for working with such ... anyway, while I can't answer the above directly, I can talk more generally about I18N and Java. Is the text in question actually UTF-8? i.e. if you run it through iconv -f utf-8 -t utf-8, do you get an error? If you're testing at the command line, you can put it in a file and look to see what you get. When doing I18N w/ Java, I've found that using UTF-8 as JVM-default tends to cause problems, because converting bytes into strings and back (which programmers tend to do without realizing this is a potentially lossy operation) will mangle binary data which is not actually UTF-8 -- as would be the cause w/ ISO-8859-1 (the charset in which this message was sent). Umlaut is a character in ISO-8859-1 with the high bit set; but it's not part of a proper UTF-8 byte sequence, so it will cause Linux's conversion utilities to halt at that point when in the strict mode. (iconv will show an error unless -c is provided; if -c is provided, it will just omit the characters. Java's readers tend to throw exceptions, but string's constructor transforms unknown bytes or byte sequences into question marks.) That might explain the EOF after "" -- if the JVM did a conversion from bytes to a String but ceased conversion with an internal error after the first byte with the high bit set). In Windows, are you sure the file.encoding property has taken, and that it is the default for conversion of bytes to Strings? cheers -- Ed |
From: <dd...@bi...> - 2004-01-02 18:15:44
|
I appreciate your reply. Here are my response to your analysis. 1) I tried iconv -f utf-8 -t utf-8 filename on Linux system and there is no error. I had umlaut in the file. 2) In Windows XP file.encoding is infact Cp1252. I guess this one is not lossy for Umlaut and other Latin-1 characters. 3) Since my database is on UTF-8, I want keep JVM on UTF-8 as well. Still I am going to try using UTF-16 for the JVM. I have not tried yet. 4) On Linux when I pass the script to the jython interpreter in "ISO-8859-1" encoding it works fine. For example following code works fine. String utfScript = "a=\"ü\""; byte[] bytes = utfScript.getBytes("UTF-8"); String isoScript = new String(bytes, "ISO-8859-1"); intertpreter.exec(isoScript); Please note JVM System property for file.encoding is UTF-8. Thanks Dipankar ----- Original Message ----- From: "Ed Korthof" <ed...@ap...> To: "Dipankar Das" <dd...@bi...> Cc: <jyt...@li...> Sent: Thursday, January 01, 2004 4:04 PM Subject: Re: [Jython-users] How to make jython work with UTF-8 On Tue, Dec 30, 2003 at 01:47:55PM -0800, Dipankar Das wrote: > >From java class I call the follwoing line of code. > intertpreter.exec(a='ü') > > Same code works fine on WindowsXP. I cannot run it on Linux. "file.encoding" > property for JVM has been set to "UTF-8". On Linux I get the following > error. > > SyntaxError: LexicalError at line 1, column 5. Encountered: <EOF> after: "" [snip] > > What are the necessary steps to configure jython to accept and return > UTF-8 > > characters. [snip] I haven't done I18N work in Jython, except with libraries that were already doing the conversion. Jython certainly handles unicode data fine if other code has done the conversion from UTF-8 to the internal unicode representation (in Java, it's a UTF-16 variant). And Java has a number of idioms for working with such ... anyway, while I can't answer the above directly, I can talk more generally about I18N and Java. Is the text in question actually UTF-8? i.e. if you run it through iconv -f utf-8 -t utf-8, do you get an error? If you're testing at the command line, you can put it in a file and look to see what you get. When doing I18N w/ Java, I've found that using UTF-8 as JVM-default tends to cause problems, because converting bytes into strings and back (which programmers tend to do without realizing this is a potentially lossy operation) will mangle binary data which is not actually UTF-8 -- as would be the cause w/ ISO-8859-1 (the charset in which this message was sent). Umlaut is a character in ISO-8859-1 with the high bit set; but it's not part of a proper UTF-8 byte sequence, so it will cause Linux's conversion utilities to halt at that point when in the strict mode. (iconv will show an error unless -c is provided; if -c is provided, it will just omit the characters. Java's readers tend to throw exceptions, but string's constructor transforms unknown bytes or byte sequences into question marks.) That might explain the EOF after "" -- if the JVM did a conversion from bytes to a String but ceased conversion with an internal error after the first byte with the high bit set). In Windows, are you sure the file.encoding property has taken, and that it is the default for conversion of bytes to Strings? cheers -- Ed ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id78&alloc_id371&op=ick _______________________________________________ Jython-users mailing list Jyt...@li... https://lists.sourceforge.net/lists/listinfo/jython-users |
From: Julio P. A. <pe...@lu...> - 2003-12-17 09:05:12
|
Hi, I have a jython interpreter which I have defined "logout" in order to ex= it, so in the python.jjt I have defined the "logout" word to exit, when I try= ed to use also "exit" or "quit" it returns me a duplicated error, how could = be possible to add those new words? Thanks in advance! Julio. -----Mensaje original----- De: jyt...@li... [mailto:jyt...@li...]En nombre de Updike, Clark Enviado el: mi=E9rcoles, 17 de diciembre de 2003 6:23 Para: 'jyt...@li...' Asunto: RE: [Jython-users] Fw: Connecting Ms Excel If your using wxpython to access excel and want to keep doing that, your only hope might be cyphon, which is probably vaporware: <http://lists.wxwindows.org/archive/wxPython-users/msg09122.html> <http://www.geocrawler.com/archives/3/7017/2002/10/0/10030291/> If you can give up wxpython, I've heard POI is decent. Since it's just java, you can use it from jython. I'm sure there are others: <http://www.javaworld.com/javaworld/javaqa/2002-05/01-qa-0503-excel3.html= > Google is your friend... search on: jython excel jython wxpython -Clark -----Original Message----- From: Subbu Sent: Tuesday, December 16, 2003 11:43 PM Subject: [Jython-users] Fw: Connecting Ms Excel Hi, I am currently working onJython and developing a test module for the Java application we have. I would like to connect to Ms Excel and retrieve dat= a from it for further testing. I beleive it is possible because i have done= it in Python using win32com.client. Now, how do i do it in Jython... Awaiting reply and thanx in advance Regards & Thanks Subramanian.S (SSB) *: 91 - 44 - 2825 5541 Extn.2023 S R A S Y S T E M S L I MI T E D Start from where you are not from where you want to be. ------------------------------------------------------- This SF.net email is sponsored by: IBM Linux Tutorials. Become an expert in LINUX or just sharpen your skills. Sign up for IBM's Free Linux Tutorials. Learn everything from the bash shell to sys admin. Click now! http://ads.osdn.com/?ad_id=3D1278&alloc_id=3D3371&op=3Dclick _______________________________________________ Jython-users mailing list Jyt...@li... https://lists.sourceforge.net/lists/listinfo/jython-users |