基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

excel 转 txt

unit Unit1;
 
interface
 
uses
  Windows, Messages, SysUtils, Variants, Classes, Graphics, Controls, Forms,
  Dialogs, StdCtrls, Grids;
 
type
  TForm1 = class(TForm)
    Button1: TButton;
    OpenDialog1: TOpenDialog;
    procedure Button1Click(Sender: TObject);
  private
    { Private declarations }
  public
    { Public declarations }
  end;

var
  Form1: TForm1;
 
implementation
 
{$R *.dfm}
 
uses Comobj, Clipbrd;
 
procedure TForm1.Button1Click(Sender: TObject);
var
  FExcel: Variant;
  FWorkbook: Variant;
  FWorksheet: Variant;
  slText: TStringList;
begin
  if not OpenDialog1.Execute then
    exit;
 
  Screen.Cursor := crHourGlass;

  try
    FExcel := CreateOleObject('excel.application');
  except
    Screen.cursor := crDefault;
    MessageDlg('Could not start Microsoft Excel!', mtError, [mbCancel], 0);
    Exit;
  end;
 
  try
    FWorkBook := FExcel.WorkBooks.Open(OpenDialog1.Filename);
    //FWorkSheet := FWorkBook.WorkSheets.Add;
    FWorkSheet := FWorkBook.WorkSheets[1];
    FWorkSheet.UsedRange.Copy;
 
 
    slText := TStringList.Create;
    try
      slText.Text := Clipboard.AsText;
      slText.SaveToFile(ChangeFileExt(OpenDialog1.Filename, '.txt'));
    finally
      slText.Free;
    end;
  finally
    Screen.Cursor := crDefault;
    FExcel.DisplayAlerts := False;
    FWorkBook.Close;
    FExcel.Quit;
  end;
end;
 
end.