using Spire.Xls;
using System.IO;

class Program
{
    static void Main(string[] args)
    {
        // 加載Excel文件
        Workbook workbook = new Workbook();
        workbook.LoadFromFile("Sample.xlsx");

        // 獲取第一個(gè)工作表
        Worksheet worksheet = workbook.Worksheets[0];

        // 創(chuàng)建輸出文本文件
        string outputFile = "Output.txt";
        StreamWriter writer = new StreamWriter(outputFile);

        // 遍歷工作表的行和列，并將數(shù)據(jù)寫入文本文件
        for (int row = 1; row <= worksheet.LastRow; row++)
        {
            for (int col = 1; col <= worksheet.LastColumn; col++)
            {
                CellRange range = worksheet.Range[row, col];
                string cellValue = range.Text == null ? string.Empty : range.Text.ToString();
                writer.Write(cellValue + "\t"); // 使用制表符作為單元格數(shù)據(jù)的分隔符
            }
            writer.WriteLine(); // 寫入換行符
        }

        // 關(guān)閉寫入器并保存文本文件
        writer.Close();

        // 釋放資源
        workbook.Dispose();
    }
}

using Spire.Xls;
using System.Data;

namespace ExcelToAccess
{
    class Program
    {
        static void Main(string[] args)
        {
            // 創(chuàng)建Workbook類的對(duì)象
            Workbook workbook = new Workbook();

            // 加載Excel文件
            workbook.LoadFromFile("Sample.xlsx");

            // 獲取第一個(gè)工作表
            Worksheet worksheet = workbook.Worksheets[0];

            // 將工作表中的數(shù)據(jù)導(dǎo)出到一個(gè)DataTable對(duì)象
            DataTable dataTable = worksheet.ExportDataTable();

            workbook.Dispose();
        }
    }
}

using Spire.Xls;
using System.Data.OleDb;

class Program
{
    static void Main(string[] args)
    {
        // 設(shè)置Excel文件路徑
        string excelFilePath = "Sample.xlsx";
        // 設(shè)置Access數(shù)據(jù)庫文件路徑
        string accessDbFilePath = "Sample.accdb";

        // 加載Excel文件
        Workbook workbook = new Workbook();
        workbook.LoadFromFile(excelFilePath);

        // 獲取第一個(gè)工作表
        Worksheet worksheet = workbook.Worksheets[0];

        // 使用工作表名稱作為表名
        string tableName = worksheet.Name;

        // 獲取第一行作為列名
        CellRange headerRange = worksheet.Rows[0];
        string[] columnNames = new string[headerRange.Columns.Length];
        for (int i = 0; i < headerRange.Columns.Length; i++)
        {
            columnNames[i] = headerRange.Columns[i].Value.Replace(" ", "_");
        }

        // 連接到Access數(shù)據(jù)庫
        string connectionString = $"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={accessDbFilePath};Persist Security Info=False;";
        using (OleDbConnection connection = new OleDbConnection(connectionString))
        {
            connection.Open();

            // 創(chuàng)建表
            string createTableQuery = $"CREATE TABLE [{tableName}] ({string.Join(", ", columnNames.Select(c => $"[{c}] Memo"))})";
            using (OleDbCommand createTableCommand = new OleDbCommand(createTableQuery, connection))
            {
                createTableCommand.ExecuteNonQuery();
            }

            // 插入數(shù)據(jù)
            string insertQuery = $"INSERT INTO [{tableName}] ({string.Join(", ", columnNames.Select(c => $"[{c}]"))}) VALUES ({string.Join(", ", columnNames.Select(c => $"@{c}"))})";
            using (OleDbCommand insertCommand = new OleDbCommand(insertQuery, connection))
            {
                foreach (CellRange row in worksheet.Rows.Cast().Skip(1))
                {
                    for (int i = 0; i < row.Columns.Length; i++)
                    {
                        insertCommand.Parameters.AddWithValue($"@{columnNames[i]}", row.Columns[i].Value);
                    }

                    insertCommand.ExecuteNonQuery();
                    insertCommand.Parameters.Clear();
                }
            }

            connection.Close();
            workbook.Dispose();
        }
    }
}