winforms 用于填充组合框的C# Gembox电子表格

zzoitvuj 于 2022-12-23 发布在 C#

关注(0)|答案(1)|浏览(133)

我正在编写一个程序，使用的组合框是从csv文件填充，我最初只是使用streamreader来填充组合框，但我被指示使用gembox电子表格来填充它代替。
下面是我使用的流阅读器代码：

private static List<ItemLine> Readfile(string fileName, string defaultValueDescription)
    {
        string path = $".\\Backend Files\\{fileName}";
        var items = new List<ItemLine>();
        int row = 0;
        //read the file
        StreamReader reader = new StreamReader(path);
        while (reader.EndOfStream == false)
        {
            string lines = reader.ReadLine();
            row++;
            if (row == 1)
            {
                items.Add(new ItemLine { Description = defaultValueDescription, Quantity = 0 });
                continue;
            }
            string[] itemFields = lines.Split(",");
            ItemLine IL = new ItemLine();
            if (itemFields.Length == 2)
            {
                IL.Description = itemFields[0];
                IL.Quantity = 0;
                if (int.TryParse(itemFields[1], out int qty))
                {
                    IL.Quantity = qty;
                }
            }
            else if (itemFields.Length >= 3)
            {
                IL.Plan = itemFields[0];
                IL.Description = itemFields[1];
                IL.Quantity = 0;
                if (int.TryParse(itemFields[2], out int qty))
                {
                    IL.Quantity = qty;
                }
            }
            ///Add Items to List
            items.Add(IL);
        }
        reader.Close();
        return items;

    }

这里是一个例子，我用gembox电子表格在我的程序的另一部分，我用它来更新csv文件，我想我试图弄清楚的代码看起来像：

public void updateFile(string filename, int range, ItemLine selectedItem, decimal outValue)
    {
        var fullPath = $".\\Backend Files\\{filename}";
        SpreadsheetInfo.SetLicense("FREE -LIMITED-KEY");
        var workbook = ExcelFile.Load(fullPath, new CsvLoadOptions(CsvType.CommaDelimited));
        var worksheet = workbook.Worksheets[0];
        for (int i = 1; i <= range; i++)
        {
            var plan = worksheet.Rows[i].Cells[0].Value;
            var desc = worksheet.Rows[i].Cells[1].Value;
            var csvDescription = plan + " - " + desc;
            var platedescription = plan + " - ";
            if (selectedItem.ComboDescription == csvDescription)
            {
                worksheet.Rows[i].Cells[2].Value = outValue;
            }
            if (selectedItem.plateDescription == platedescription)
            {
                worksheet.Rows[i].Cells[1].Value = outValue;
            }
        }
        workbook.Save(fullPath, new CsvSaveOptions(CsvType.CommaDelimited));
    }

winforms

来源：https://stackoverflow.com/questions/74854553/c-sharp-gembox-spreadsheet-to-populate-combobox

1条答案

按热度按时间

n7taea2i1#

试试这个：

private static List<ItemLine> ReadFile(string fileName, string defaultValueDescription)
{
    string path = $".\\Backend Files\\{filename}";
    var workbook = ExcelFile.Load(path, new CsvLoadOptions(CsvType.CommaDelimited));
    var worksheet = workbook.Worksheets[0];

    var items = new List<ItemLine>();
    items.Add(new ItemLine { Description = defaultValueDescription, Quantity = 0 });

    foreach (var row in worksheet.Rows)
    {
        var cells = row.AllocatedCells;

        var il = new ItemLine();
        items.Add(il);

        if (cells.Count == 2)
        {
            il.Description = cells[0].Value.ToString();
            il.Quantity = cells[1].ValueType == CellValueType.Int ? cells[1].IntValue : 0;
        }
        else if (cells.Count >= 3)
        {
            il.Plan = cells[0].Value.ToString();
            il.Description = cells[1].Value.ToString();
            il.Quantity = cells[2].ValueType == CellValueType.Int ? cells[2].IntValue : 0;
        }
    }

    return items;
}

另外，我不确定defaultValueDescription的逻辑，似乎在您的StreamReader方法中，您只是因为它而跳过了CSV中的第一行。
如果这是预期的行为，则从System.linq添加.Skip(1)扩展方法，如下所示：

foreach (var row in worksheet.Rows.Skip(1))
{
    // ...
}

赞(0）回复(0）举报 2022-12-23

我来回答

winforms 用于填充组合框的C# Gembox电子表格

1条答案

相关问题

热门标签

最新问答