Exporting all model data to a CSV

Temporal Nightmare · 2024-01-06T19:33:25.956Z

Hello. I have successfully pulled data out of a custom .sdb (not sqlite), from a old game and was trying to save it to a .CSV so I can import it into a database later (SQLite). I can do the last part just fine but getting a bit lost on the Export side. Thank you in advance.

T

Temporal NightmareOP•1/6/24, 10:26 PM

        private void ExportToCSV()
        {
            var stringBuilder = new StringBuilder();

            var headers = StringGridView.Columns.Cast<DataGridViewColumn>();

            stringBuilder.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()));

            foreach (DataGridViewRow row in StringGridView.Rows)
            {
                var cells = row.Cells.Cast<DataGridViewCell>();
                stringBuilder.AppendLine(string.Join(",", cells.Select(cell => "\"" + cell.Value + "\"").ToArray()));
            }

            File.WriteAllText(Application.StartupPath + @"\outputEnglish.csv", stringBuilder.ToString());
        }

        private void ExportToCSV()
        {
            var stringBuilder = new StringBuilder();

            var headers = StringGridView.Columns.Cast<DataGridViewColumn>();

            stringBuilder.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()));

            foreach (DataGridViewRow row in StringGridView.Rows)
            {
                var cells = row.Cells.Cast<DataGridViewCell>();
                stringBuilder.AppendLine(string.Join(",", cells.Select(cell => "\"" + cell.Value + "\"").ToArray()));
            }

            File.WriteAllText(Application.StartupPath + @"\outputEnglish.csv", stringBuilder.ToString());
        }

        private void ExportToCSV()
        {
            var stringBuilder = new StringBuilder();

            var headers = StringGridView.Columns.Cast<DataGridViewColumn>();

            stringBuilder.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()));

            foreach (DataGridViewRow row in StringGridView.Rows)
            {
                var cells = row.Cells.Cast<DataGridViewCell>();
                stringBuilder.AppendLine(string.Join(",", cells.Select(cell => "\"" + cell.Value + "\"").ToArray()));
            }

            File.WriteAllText(Application.StartupPath + @"\outputEnglish.csv", stringBuilder.ToString());
        }

        private void ExportToCSV()
        {
            var stringBuilder = new StringBuilder();

            var headers = StringGridView.Columns.Cast<DataGridViewColumn>();

            stringBuilder.AppendLine(string.Join(",", headers.Select(column => "\"" + column.HeaderText + "\"").ToArray()));

            foreach (DataGridViewRow row in StringGridView.Rows)
            {
                var cells = row.Cells.Cast<DataGridViewCell>();
                stringBuilder.AppendLine(string.Join(",", cells.Select(cell => "\"" + cell.Value + "\"").ToArray()));
            }

            File.WriteAllText(Application.StartupPath + @"\outputEnglish.csv", stringBuilder.ToString());
        }

T

Temporal NightmareOP•1/6/24, 10:26 PM

AI helped, it seems to work okay.

D

Denis•1/8/24, 6:19 AM

$close

DDenis $close

M

MODiX•1/8/24, 6:19 AM

Use the </close:1007753098107813888> command to mark a forum thread as answered

Exporting all model data to a CSV

Similar Threads

Similar Threads

Similar Threads