How to open excel file in skill

You can use axlRunBatchDBProgram.

You may need to put in the complete path to excel.exe

--Jerry

Hi Jerry!

Thank for your reply, I have tried to set follow your advice but it still returm Error   'E- Unable to start program; excel

Here my code:

..........................        

   axlSpreadsheetWrite("Count_Via_By_Netlist.xls")
            axlSpreadsheetClose()

axlRunBatchDBProgram("excel" "C:\Program Files (x86)\Microsoft Office\OFFICE11\excel.exe Count_Via_By_Netlist %s", ?reloadDB nil ?noUnload t)

..............................

I'm really  not understand function axlRunBatchDBProgram clearly. please show me more.

Tks.

Luan.

Hi EDave!

I have used function axlHttp () to open xls file, but not successful , it return nil. I don't know why, i think excel program have registered as  default web browser  in the Windows registry. 

Tks.

Luan.

Hello,

If its a csv file delimited by same ,(comma) you want to open then you can open using regular file function infile, use gets to read lines from file as string and axlStringCSVParse to parse String as csv. Hope it helps

For example if one has csv file,Book1.csv as following

Instrument,CP,SP,Profit
Keyboard,10.00 ,12.00 ,2.00
Monitor,3.00 ,4.00 ,1.00
Mouse,10.00 ,10.00 ,0.00

Then Skill code to read the file and parse it as follows:

csvFile = infile("Book1.csv") ; open the file for reading

(while gets(curStr csvFile) ;gets reads a line from the input port and stores it as a string in a variable
printf("curStr is %s\n" curStr)
parsedStr=axlStringCSVParse(curStr) ;Parses a comma delimited line
printf("parsedStr is %L count %d\n" parsedStr length(parsedStr))
)

close(csvFile)

Output of running the load the skill file is:

Command > skill load "excel.il"
curStr is Instrument,CP,SP,Profit

parsedStr is ("Instrument" "CP" "SP" "Profit") count 4
curStr is Keyboard,10.00 ,12.00 ,2.00

parsedStr is ("Keyboard" "10.00 " "12.00 " "2.00 ") count 4
curStr is Monitor,3.00 ,4.00 ,1.00

parsedStr is ("Monitor" "3.00 " "4.00 " "1.00 ") count 4
curStr is Mouse,10.00 ,10.00 ,0.00

parsedStr is ("Mouse" "10.00 " "10.00 " "0.00 ") count 4

Notes:

gets reads a line from the input port and stores it as a string in a variable. The string is also returned as the value of gets. The terminating newline character of the line becomes the last character in the string. gets returns nil if EOF is encountered and the variable maintains its last value

axlStringCSVParse(
t_string
[g_stripWhite]
) -> lt_string/nil
Description
Parses a comma delimited line (typical from Excel). This differs from the Skill prehistorian function in several areas which make it compatible with Excel csv file format:
■ parseString ignores two adjacent commas.
■ if a comma is contained within a cell, Excel quotes the cell. parseString treats this as
two cells.
■ Correctly processes double quotes in a cell.

Arguments
t_string A csv string
g_stripWhite Option to strip leading and trailing white space from each output
string. Default is to leave whitespace.

Value Returned
lt_string list of strings parsed based on comma separator.
nil error (unlikely to happen)