tablecsv, C# - rextester

tablecsv

//Rextester.Program.Main is the entry point for your code. Don't change it.
//Compiler version 4.0.30319.17929 for Microsoft (R) .NET Framework 4.5

using System.Text;

using Autodesk.AutoCAD.ApplicationServices;

using Autodesk.AutoCAD.DatabaseServices;

using Autodesk.AutoCAD.EditorInput;

using Autodesk.AutoCAD.Runtime;

using System;

using System.IO;

namespace TableExportUnicode

{

public class Commands

{

[CommandMethod("TABLEEXPORT2", CommandFlags.UsePickSet)]

static public void ExportTableToUnicode()

{

var doc =

Application.DocumentManager.MdiActiveDocument;

var db = doc.Database;

var ed = doc.Editor;

var tbId = ObjectId.Null;

// Check the pickfirst selection for a single Table object

var psr = ed.GetSelection();

if (psr.Status != PromptStatus.OK)

return;

if (psr.Value.Count == 1)

{

var selId = psr.Value[0].ObjectId;

if (

selId.ObjectClass.IsDerivedFrom(

RXObject.GetClass(typeof(Table))

)

{

tbId = selId;

}

if (tbId == ObjectId.Null)

{

// If no Table already selected, ask the user to pick one

var peo = new PromptEntityOptions("\nSelect a table");

peo.SetRejectMessage("\nEntity is not a table.");

peo.AddAllowedClass(typeof(Table), false);

var per = ed.GetEntity(peo);

if (per.Status != PromptStatus.OK)

return;

tbId = per.ObjectId;

}

// Ask the user to select a destination CSV file

var psfo = new PromptSaveFileOptions("Export Data");

psfo.Filter = "Comma Delimited (*.csv)|*.csv";

var pr = ed.GetFileNameForSave(psfo);

if (pr.Status != PromptStatus.OK)

return;

var csv = pr.StringResult;

// Our main StringBuilder to get the overall CSV contents

var sb = new StringBuilder();

using (var tr = db.TransactionManager.StartTransaction())

{

var tb = tr.GetObject(tbId, OpenMode.ForRead) as Table;

// Should be a table but we'll check, just in case

if (tb != null)

{

for (int i = 0; i < tb.Rows.Count; i++)

{

for (int j = 0; j < tb.Columns.Count; j++)

{

if (j > 0)

{

sb.Append(",");

}

// Get the contents of our cell

var c = tb.Cells[i, j];

var s = c.GetTextString(FormatOption.ForEditing);

// This StringBuilder is for the current cell

var sb2 = new StringBuilder();

// Create an MText to access the fragments

using (var mt = new MText())

{

mt.Contents = s;

var fragNum = 0;

mt.ExplodeFragments(

(frag, obj) =>

{

// We'll put spaces between fragments

if (fragNum++ > 0)

{

sb2.Append(" ");

}

// As well as replacing any control codes

sb2.Append(ReplaceControlCodes(frag.Text));

return MTextFragmentCallbackStatus.Continue;

}

);

// And we'll escape strings that require it

// before appending the cell to the CSV string

sb.Append(Escape(sb2.ToString()));

}

// After each row we start a new line

sb.AppendLine();

}

tr.Commit();

}

// Get the contents we want to put in the CSV file

var contents = sb.ToString();

if (!String.IsNullOrWhiteSpace(contents))

{

try

{

// Write the contents to the selected CSV file

using (

var sw = new StreamWriter(csv, false, Encoding.UTF8)

)

{

sw.WriteLine(sb.ToString());

}

catch (System.IO.IOException)

{

// We might have an exception, if the CSV is open in

// Excel, for instance... could also show a messagebox

ed.WriteMessage("\nUnable to write to file.");

}

public static string ReplaceControlCodes(string s)

{

// Check the string for each of our control codes, both

// upper and lowercase

for (int i=0; i < CODES.Length; i++)

{

var c = "%%" + CODES[i];

if (s.Contains(c))

{

s = s.Replace(c, REPLS[i]);

}

var c2 = c.ToLower();

if (s.Contains(c2))

{

s = s.Replace(c2, REPLS[i]);

}

return s;

}

// AutoCAD control codes and their Unicode replacements

// (Codes will be prefixed with "%%")

private static string[] CODES = { "C", "D", "P" };

private static string[] REPLS = { "\u00D8", "\u00B0", "\u00B1" };

public static string Escape(string s)

{

if (s.Contains(QUOTE))

s = s.Replace(QUOTE, ESCAPED_QUOTE);

if (s.IndexOfAny(MUST_BE_QUOTED) > -1)

s = QUOTE + s + QUOTE;

return s;

}

// Constants used to escape the CSV fields

private const string QUOTE = "\"";

private const string ESCAPED_QUOTE = "\"\"";

private static char[] MUST_BE_QUOTED = {',', '"', '\n'};

}


run \| edit \| history \| help	0