Files Masato SHIMURA JCD02773@nifty.ne.jp 2004/12/11 last update 2005/02/05 1 2 1.1 WINDOWS................................. 2 2 2 2.1 EXCEL OLE................................ 2 2.2 CSV.................................. 5 3 6 3.1 clip........................................ 6 3.2 wmf bmp.................................... 6 3.3 pdf........................................ 7 4 Grid 7 5 Box and General Array 8 6 HTML 10 6.1 Boxed data.................................... 10 6.2 J HTML................................... 11
1 1.1 WINDOWS 1.1.1 ijs.,j 1.1.2 RUN/FILE, (ALT+ R F) 1.1.3 WINDOWS FILE/OPEN RUN/WINDOW WINDOW (ALT+F O) (ALT+R W),, RUN/WINDOU(ALT+R W), YES/NO 2 2.1 EXCEL OLE getexcel.ijs, J
EXCEL getexcel.ijs 3 1. test.xls 2. 3. 0 1. getexcel.ijs,/user/ijs 2. ijx RUN/FILE getexcel.ijs 3. ijx getexcel EXCEL YES/NO YES WINDOWS, EXCEL / (O)/Cell(E)/ / / /. getexcel.ijs, EX- CEL getexcel
1. EXCEL 2. Copy 3. TRY 4. / (ijx tmp=:datain a b c d tmp=: datain 1 1 29 6 1 1 29 6 a EXCEL b EXCEL c d tmp =: ( EXCEL. tmp A TMP DATA
EX- CEL foo dataout a b e.g.( dat=. i. 3 3 dat dataout 1 1 dat dataout 10 1 2.2 CSV csv.ijs load csv files CSV readcsv foo.csv ( foo main.ijs) ), TDATA0 =: ".@> readcsv user\odbc\traffic_test_03.csv TDATA1 =: ".@> readcsv user\odbc\add_01.csv NB. add Feb/2003-APR/2004 writecsv file 2.2.1 EXCEL CSV EXCEL csv EXCEL copy csv Sheet J
3 3.1 clip,, load plot plot 1&o. i. 20 pd clip, HTML PDF,EPS png 3.2 wmf bmp bmp wmf. polt Command pd save foo w h pd savebmp foo w h plot 1&o. i. 20 pd savebmp test 1000 1000 pd save test 10000 10000 pd save c:\language\j502\temp\test 1000 1000,J.
3.3 pdf pd clip * WINDOWD paint paintshop pro, eps, TEX,,PDF, PDF Oleg Kobchenco. Oleg plotpdf.ijs http://www22.brinkster.com/olegyk/j/ J504 pdf,eps plotpdf test.pdf 3850,,J. TEX,.,TEX Bounding Box. ebb filename.pdf foo.bb bb. %%Bounding Box a b c d a b c d 1/72 inch 4 Grid J Grid J over,by a conew jwatch foo conew jwatch jwatch require jwatch a=. i. 5 6 a conew jwatch
+-+ 2 +-+ 1 Grid Jwatch 5 Box and General Array J Box Box 3 APL2 General Array J Box General Array EXCEL CSV,Grid 2 export 2
2 3 Box a2=.< a=.<"2 i.3 3 5 +----------------------------------------------+ +--------------+--------------+--------------+ 0 1 2 3 4 15 16 17 18 19 30 31 32 33 34 5 6 7 8 9 20 21 22 23 24 35 36 37 38 39 10 11 12 13 14 25 26 27 28 29 40 41 42 43 44 +--------------+--------------+--------------+ +----------------------------------------------+,. L:0>L:1 a2 +--------------------------------------------+ 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 +--------------------------------------------+
a3=. ;a a3 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 >L:1 a2 +--------------+ 0 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 +--------------+ a3 conew jwatch OK 6 HTML 6.1 Boxed data http://www22.brinkster.com/olegyk/j/ Oleg okhtml2.zip.,html.ijs,box, HTML. html tag body tag html y.* html tag body tag * <html><body><body /html / J HTML,,Editor,extention html, box. load files HTML f oo f write temp/ f oo.html
html tag body tag html <i. 3 3 <html><body><table border="1" cellpadding="5" cellspacing="0"> <tr><td valign="top"><tt>0 1 2<br> 3 4 5<br> 6 7 8</tt></td></tr> </table> </body></html> Box, HTML (< data) <, EXCEL DB,J,. 2 Oleg HTML Oleg J503 okhtml2.ijs j504) 6.2 J HTML J HTML
RUN HT ML publish HTML Publisher publisher save J HTML