Welcome, Guest. Please login or register.
Did you miss your activation email?


Login with username, password and session length

Search

 
Advanced search

19273 Posts in 2522 Topics- by 907 Members - Latest Member: lazyman
Pages: [1]   Go Down
Print
Author Topic: XLS u XML ili MySQL  (Read 753 times)
Tomislav
MODERATOR
Sr. Member
*
Offline Offline

Posts: 280



View Profile
« on: 18.02.2008; 04:40:01 AM »

Zna netko neku skriptu koja .xls (excel tablicu) prebacuje u .xml.

Može i samo da čita iz tablice i ima primjer ispisa, ostalo je lako.

Imam čovjeka koji ima podatke u tablici, sve uredno i fino, a ja bi to trebao u bazu ukucat. Ne bi bio problem da nema 15 000 redaka ...
Logged

kraguljac
Hero Member
*****
Offline Offline

Posts: 566



View Profile WWW
« Reply #1 on: 18.02.2008; 05:13:28 AM »

Jesi li probao Save As, pa onda XML?
Logged

Agencija KRAGULJAC - www.kraguljac.com
Ne pišem ja, nego Isidora - isidora.kraguljac.com
Ne piše Isidora, nego ja - blog.kraguljac.com
Sve o Banji na jednom mestu - www.36210vrnjackabanja.com
Tomislav
MODERATOR
Sr. Member
*
Offline Offline

Posts: 280



View Profile
« Reply #2 on: 18.02.2008; 05:40:13 AM »

Jesi li probao Save As, pa onda XML?

Jesam, ali mi javi nešto u stilu XML maps cannot be ... nešto.
Logged

kraguljac
Hero Member
*****
Offline Offline

Posts: 566



View Profile WWW
« Reply #3 on: 18.02.2008; 05:53:23 AM »

Možda iz OpenOffice-a?
Logged

Agencija KRAGULJAC - www.kraguljac.com
Ne pišem ja, nego Isidora - isidora.kraguljac.com
Ne piše Isidora, nego ja - blog.kraguljac.com
Sve o Banji na jednom mestu - www.36210vrnjackabanja.com
Tomislav
MODERATOR
Sr. Member
*
Offline Offline

Posts: 280



View Profile
« Reply #4 on: 18.02.2008; 06:21:00 AM »

Evo, našao sam upravo ono što sam tražio.

Code:
<?php
$strSheetName 
'Sheet1';
$strCellName '';

$objXLApp = new COM"excel.application" ) or die( "unable to start MSExcel" );
$objXLApp->Workbooks->Open"c:\\test.xls" );
$objXLSheet $objXLApp->ActiveWorkBook->WorkSheets$strSheetName );

$strCellName='A1';
$objXLCell $objXLSheet->Range($strCellName);
print "ime: " $objXLCell->Value() ."<br>";

$strCellName 'B1'.$row;
$objXLCell $objXLSheet->Range($strCellName);
print "prezime: " $objXLCell->Value() ."<br><br>";


// must do all of these to release resources correctly...

unset( $objXLCell );
unset( 
$objXLSheet );

$objXLApp->ActiveWorkBook->Close();
$objXLApp->Quit();

unset( 
$objXLApp );

?>

Logged

nedim
Web Developer
SITE ADMIN
Hero Member
*
Offline Offline

Posts: 1448



View Profile WWW
« Reply #5 on: 18.02.2008; 13:53:17 PM »

Neko mi rece da je ta "Save As" opcija jedino moguca sa Microsoft Office Excel 2007 Enterprise  Blink
Logged

nosidam
Hero Member
*****
Offline Offline

Posts: 549


Bojan Mihajlovic


View Profile
« Reply #6 on: 18.02.2008; 15:26:58 PM »

Video sam da postoji neki makro koji XLS u XML konvertuje.

Ja imam Office 2007 i save as radi.

Evo jedan dodatni link i opis i makro.
http://www.softinterface.com/Convert-XLS/Features/Convert-XLSM-To-XLS.htm
http://www.google.com/search?hl=en&q=XLS+in+XML+macro

Logged
Tomislav
MODERATOR
Sr. Member
*
Offline Offline

Posts: 280



View Profile
« Reply #7 on: 18.02.2008; 23:13:01 PM »

Imam sve moguće i nemoguće. Ali ne radi.

Ipak, ova skripta mi je bogom dana jer radim samo jednom (xls direkt u bazu).
Logged

Pages: [1]   Go Up
Print
Jump to: