Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Get values from xls file
#1
Hello

Do you have any idea how i can set in My macro a value from à xls file wich contain "config" data for my macro ? 

For example 
________
Qm 
   Int cookies
   *get xls box B3*
Out cookies
_______
Xls 
   Box B3 = 5

I woud like to do it without using mousse and keyboard 
It can be à txt file if xls is not possible.
#2
Macro Macro122
Code:
Copy      Help
Database d.Open(d.CsExcel("$documents$\Book1.xls"))
ARRAY(str) a
d.QueryArr("SELECT * FROM [Sheet1$]" a)
int row
for row 0 a.len
,out F"{a[0 row]} {a[1 row]}"

But it is slow. I would use XML file or registry.
#3
Ok i Will try both thanks !
#4
Hello

My projet is up to à next stage, and now i would need to edit the Xls file

Im not rly good at sql, but it seem that it's more for reading than writing

Do someone can make an example how to set a value in an Xls
(or give me the keyword to search il the Good direction)


Forum Jump:


Users browsing this thread: 1 Guest(s)