Convert xml to xls?
does anyone know about an open-source tool or method that can convert
a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
data in the OpenOffice program Calc? The problem is that the original
xml file can be very long and the digit precision of some data fields
is strictly required. Thanks a lot!
On Oct 21, 3:16=A0pm, Jie <Jie....@gmail.com> wrote:
> Hi all,
> does anyone know about an open-source tool or method that can convert
> a certain xml file to a spreadsheet (e.g. xls)? Can one import xml
Imagine that the page contains a table with 2 columns and 3 rows, e.g.:
| A | B |
| C | D |
| E | F |
and that the background colour for each cell is a different colour.
then change the background colour of the cells. So that:
cell A gets cell C's colour
cell C gets cell E's colour
cell E gets cell F's colour
cell F gets cell D's colour
cell D gets cell B's colour
cell ...convert m-file to simulink
How can I convert m-file which consist of ANN(Artificial Neural
Network) to simulink block for simulation?
Please do reply as soon as possible.
you can use your m-file in Simulink with the user-defined functions.
There is a Block matlab-fcn there. Inputs can be taken from source
blocks, outputs can be visualized in sinks, as e.g. scopes.
badariah mahbob wrote:
> How can I convert m-file which consist of ANN(Artificial Neural
> Network) to simulink block for simulation?
> Please do reply as soon as possible.
"badariah mahbob" <bardzcomel@...I need a good sas dataset to html converter
I need a good sas dataset to html converter. Does anyone have any
links to code that can do this?
...drawing coloured map
I have a file with three coloumn (theta , phi, temperature) and I want
to draw, e.g. in mollweide projection, a map in which at every point
characterized by theta and phi corresponds a coloured pixel assigned
to temperature value. How can I do this? Thank to all
On Aug 5, 11:55=A0pm, "B.M." <daniel.vetru...@gmail.com> wrote:
> hi everyone
> I have a file with three coloumn (theta , phi, temperature) and I want
> to draw, e.g. in mollweide projection, a map in which at every point
> characterized by theta and phi corresponds a coloured pixel...How to convert xls2pdf How to convert xls2txt
Where would there be a converter by email for
..xls to .pdf
or a coverter by email for
..xls to text
where you send the .xls attachment by email and get the conversion by email
or even preferable you can send the .xls attachment by email and read
it at a web link.
Don Saklad wrote:
> Where would there be a converter by email for
> .xls to .pdf
> or a coverter by email for
> .xls to text
There are others a lot more prone to answer this one, but:
XLS, as I understand it, really IS text, so mayb...Convert Current Time to Dec
This should be simple, but brain is hurting...
How do I convert a Current Time to a Decimal 6,0 (HMS)? There must be a
cleaner way then this:
Insert into Table Values
Substr(Char(CURRENT TIMESTAMP),12,2) ||
Substr(Char(CURRENT TIMESTAMP),15,2) ||
Take a peak at HOUR(), MINUTE(), and SECOND().
DEC() can also be used directly on the timestamp.
integer(dec(current timestamp) - dec(current date) * 1000000)
round(dec(current timestamp) - dec(current date) * 1000000, 0)
Simply use ...converting cd server into file server
I have a procom CDT-21 21 bay scsi cd tower. I would like to change it into
a file server by removing the scsi cd drives an replacing them with scsi
hard drives. can this be done? I already have 14 scsi hard drives laying around
and also have server 2000 os to put on it.
any answers would help.
...VBA for batch convert e00
Any one had made a vba program which using for convert e00 to shp? because I
have a lot of e00 files it need to convert to shp and then open by arcmap!
> Any one had made a vba program which using for convert e00 to shp? because
> have a lot of e00 files it need to convert to shp and then open by arcmap!
If you don't mind using a 3rd party product, our FME can do this in a number
of ways. You could just use our "batch translate" option and a couple of
clicks later you'll have everything in shape files (or even personal
geodatabase...[Info-Ingres] views and E_US100F String cannot be converted to numeric
Content-Type: text/plain; charset="us-ascii"
X-WatchGuard-AntiVirus: part scanned. clean action=allow
I have a distributed database which has a native view (named all_box_store)=
which is a select with many union all's of several registered tables.
If I run the query...
select * from c_slot_allocation a
where a.box_cid not in (
from all_box_store s
where a.project_cid =3D s.project_cid
and a.rack_cid =3D s.rack_cid
and a.slot_p...converting HH:MM to a decimal
I have 3 pairs of time in/out (24 our clock) that I need to calculate
the decimal equivalent of the total time worked for that day.
example: time in/out 08:00 10:00, 10:15 12:45, 13:45 16:50
if I use a simple select of time_out �time_ in I get 2:00,
2:30, 3:10 respectfully, or 7:35 total hours.
That is 7.58 in decimal.
Now how do I change the total hours of 7:35 to a decimal of 7.58 in a
single SQL statement? Or will I have to write a proc that does this?
...WCHAR equivalent in SQL datatype
I have to store a WCHAR in Sybase database. Can anyone tell me whether
there is any equivalent for WCHAR in the SQL datatypes. If not, how do
i proceed to store the WCHAR ?
Please help asap.
On Tue, 30 Nov 2004 23:55:19 -0800, Ketaki wrote:
> I have to store a WCHAR in Sybase database. Can anyone tell me whether
> there is any equivalent for WCHAR in the SQL datatypes. If not, how do
> i proceed to store the WCHAR ?
I assume you mean wide (multi-byte) chars. These can be stored in normal
varchar() columns (depending on the ...convert list of strings to set of regexes; convert list of strings to trie
I need a function that converts a list into a set of regexes. Like so:
string_list = ["blaa", "blab", "raaa", "rabb"]
This should return something like:
I am aware of the fact that converting the list to a *trie* would almost do
the job. But I couldn't find anything about Python modules that produce tries.
Are there any modules that I could use? Or do I have to implement it myself?
> I need a function that converts a li..."cannot convert from the charset" error message
wx 2.5.5, Gtk2, unicode, static lib, suse 9.3
when I run my application I get the a dialog box with the following
"cannot convert from the charset '@LOCALE, UTF-8, ISO-8859-15,
Except this dialog box my program seems to work fine
looking through the wx source code I seem to find this error inside
*wxCSConv::DoCreate() function (file common/strconv.cpp)
anyone experienced this error message before ? any quick fixes on linux
besides turning off the logging with wxNullLog ? Any idea why exactly
do I get the message ?
On ...The problem with the strings Convert each other
Could you help me to solve the following problem using LV7.1? Thank in advance.
How can I convert a string of "hexadecimal value" with Normal display style to other string of " the same hexadecimal value" with Hex display style?
Here's a more compact alternative. Same result and same precautions. (It acts a little bit differently if you string has e.g. spaces between hex paris.)
<img src="http://forums...converting W*dows like pathnames to file:///
I want to convert W*dows like pathnames to browser compatible links
usind sed like
"C:\Documents and Settings\whatever"
The second one could be used in W*dows and Linux as well cause Linux
allowing links to be named with an ":" in it (at least my Linux
[Debian] does) , so /C:/ could be a link to /mnt/hda1 and so on.
Unfortunately I cannot code that little bit in sed. :-(
Problems: "\" and "/" both have special meanings
Converting " " to "%20"
Converting Ge...Lotus 123
Using Lotus (release 9.6 for Windows) I have some dates entered as a
fraction (11/1993) and can display them as a number (0.0055) or as a
fraction (11/1993). I would like to convert the fraction to text "11/1993"
and then split it into the month and year. I know how to split the text,
but can't find a way to convert the original entry to text.
"Arthur Hass" wrote...
>Using Lotus (release 9.6 for Windows) I have some dates entered as a
>fraction (11/1993) and can display them as a number (0.0055) or as a
>fraction (1...how to convert GO TO (Fortran) to Matlab
Again, I need your share if you have experience in converting Fortran to Matlab. I have Fortran code working with NCL graphic library. However, I am not successful to run this fortran code in my windows PC (under cygwin). It works perfectly in LINUX, but I want to work only in one PC (windows). Therefore, I plan to convert this fortran to Matlab code, but I got problem to convert GO TO in Fortran to Matlab.
DO 250 IX=1,NX-1
C IF(X1.LT.PX1.OR.X4.GT.PX2)GO TO 250
...Question about converting data
hi everyone, i am working on my senior project. i have previously post some of my question. however, it seems that after a while, no one will reply my post anymore. Therefore, i decided to make a new post. i am using labview 8.2 and trying converting the data from the sensor. Once the sensor is powering on, it keeps sending its measuring value to the computer through the srial port. The use hi and lo bytes represent a value, and I have to read pull out the last 7 bit from hi and low bytes and put them together (so we have ...Converting movie to image
I want to convert a video file to image, the video file is in 3.GP to image file of Jpg. anyone with useful suggestions and code on how to do this
...converting data types
I am looking for a best way of modifying the column data types.
I use the Oracle 9.i
For example I have the table:
CREATE TABLE testtable (
column1 Float(126) NOT NULL CONSTRAINT TESTTABLE_COLUMN1_Primary
column2 NUMBER(15) NOT NULL);
I have the column1 with type 'DOUBLE PRECISION' [Float(126)]
and I want to perform it's conversion to any other type (for ex. to VARCHAR2
type), and this column is not empty.
If I will convert it just by
ALTER TABLE testtable MODIFY(column1 VARCHAR2(24))
I will receive t...convert a macro variable?
If I have mac var aaa
%let aaa = 510-555-1212 ;
and I hope to get a new mac var
bbb = 510.555.1212
Is there a macro function to convert,
from - to .
11 %let aaa = 510-555-1212 ;
13 %let b=%sysfunc(translate(&aaa,'.','-'));
15 %put &b;
From: jerry chiu [mailto:chiuj2@YAHOO.COM]
Sent: Wednesday, October 15, 2003 4:13 PM
Subject: convert a macro variable?
If I have mac var aaa
%let aaa = 510-555-1212 ;
and I hope to get a new mac var
bbb = 510.555.1212
Is there a ...C's static equivalent
Is there something similar to C's static keyword?
I want a single function, which has to access and modify a permanent
variable. Any solution without bundling the function to a class?
+-[ Kontra, Gergely<firstname.lastname@example.org> PhD student Room IB113 ]---------+
| http://www.mcl.hu/~kgergely "Olyan langesz vagyok, hogy |
| Mobil:(+36 20) 356 9656 ICQ: 175564914 poroltoval kellene jarnom" |
+-- Magyar php mirror es magyar php dokumentacio: http://hu.php.net --+
>>>>> "K" == KONTRA Gergely <email@example.com> ...rx2600
Long story short, I was kindly donated a working mb for an hp rx2600 Itanium
2 server (that,
if i'm not mistaken, is also used in the zx6000) alongside a 1.5ghz cpu, vrm
and fan, and some of the airflow plastics.
Anyone in Europe able to point me where I could contact-inquire-peek for a
broken unit (mb dead) for a possible transplant ?
...Convert .dbf files to mysql files
I have an application that was developed in Clipper.
70 dbf files and aroud 100 ntx , I plan to move the data to Access and Mysql
*.frm *.MYD and *.MYI,
But I don't know how to convert the .dbf files and .ntx. files ?
Thanks you help.....
Have a look at the thread from deltatrend started on the 20/8/03.....
R&D Software Pty. Ltd.