To baojianjun(包子) : 把DBGRID中的内容轉換到EXCEL,然後在打印, 能帮点忙,给点原码例子吗。谢谢啦。可以 另辟栏目给分的。
PROCEDURE TGCFP.KIT_DBG_TO_FILE(SRC_DBE:TDATASET; FHEAD,FNAME:STRING); VAR LINE_TXT:STRING; I:INTEGER; FWRITETO: TEXTFILE; BEGIN LINE_TXT:=''; ASSIGNFILE(FWRITETO,FNAME); REWRITE(FWRITETO); LINE_TXT := FHEAD; WRITELN(FWRITETO,LINE_TXT); FLUSH(FWRITETO); WITH SRC_DBE DO BEGIN FIRST; WHILE NOT EOF DO BEGIN LINE_TXT := ''; FOR I:=0 TO SRC_DBE.FIELDDEFS.COUNT-1 DO LINE_TXT := LINE_TXT + '"'+ TRIM(FIELDBYNAME(SRC_DBE.FieldDefs.Items[I].name).ASSTRING)+'"'+ ','; WRITELN(FWRITETO,LINE_TXT); FLUSH(FWRITETO); NEXT; END; END; CLOSEFILE(FWRITETO); END;
FHEAD是導出後欄位的顯示名稱,我調用的時候如下:IF SAVEDIALOG1.Execute THEN BEGIN X:=SAVEDIALOG1.FileName; IF ((X[LENGTH(X)]='V') OR (X[LENGTH(X)]='v')) AND ((X[LENGTH(X)-1]='s') OR (X[LENGTH(X)-1]='S')) and ((X[LENGTH(X)-2]='c') OR (X[LENGTH(X)-2]='C')) and (X[LENGTH(X)-3]='.') then X:=SAVEDIALOG1.FileName else X:= SAVEDIALOG1.FileName+'.csv'; END; GC.KIT_DBG_TO_FILE(QRY_CARD,'盤點卡,料號,站,實盤量,帳號,盤點時間,創建時間,狀態',X); 記得增加一個SAVEDIALOG控件,至於如何運用,就看你自己了,自己多實踐實踐:)
要把DBGRID中的内容直接打印出来~!
比方说类似这个dbgrid1.print()
密切關注
把DBGRID中的内容轉換到EXCEL,然後在打印, 能帮点忙,给点原码例子吗。谢谢啦。可以 另辟栏目给分的。
VAR
LINE_TXT:STRING;
I:INTEGER;
FWRITETO: TEXTFILE;
BEGIN
LINE_TXT:='';
ASSIGNFILE(FWRITETO,FNAME);
REWRITE(FWRITETO); LINE_TXT := FHEAD;
WRITELN(FWRITETO,LINE_TXT);
FLUSH(FWRITETO); WITH SRC_DBE DO
BEGIN
FIRST;
WHILE NOT EOF DO
BEGIN
LINE_TXT := '';
FOR I:=0 TO SRC_DBE.FIELDDEFS.COUNT-1 DO
LINE_TXT := LINE_TXT + '"'+ TRIM(FIELDBYNAME(SRC_DBE.FieldDefs.Items[I].name).ASSTRING)+'"'+ ',';
WRITELN(FWRITETO,LINE_TXT);
FLUSH(FWRITETO);
NEXT;
END;
END;
CLOSEFILE(FWRITETO);
END;
BEGIN
X:=SAVEDIALOG1.FileName;
IF ((X[LENGTH(X)]='V') OR (X[LENGTH(X)]='v')) AND ((X[LENGTH(X)-1]='s') OR (X[LENGTH(X)-1]='S'))
and ((X[LENGTH(X)-2]='c') OR (X[LENGTH(X)-2]='C')) and (X[LENGTH(X)-3]='.') then
X:=SAVEDIALOG1.FileName
else
X:= SAVEDIALOG1.FileName+'.csv';
END;
GC.KIT_DBG_TO_FILE(QRY_CARD,'盤點卡,料號,站,實盤量,帳號,盤點時間,創建時間,狀態',X);
記得增加一個SAVEDIALOG控件,至於如何運用,就看你自己了,自己多實踐實踐:)
谢谢!
canvas.textout(),然后旧随便你怎么写了
还可以画画呢?
记得在单元里面引用printer单元。
看看delphi的printer帮助就可以了
我没找到!
谢谢!