// Exports a collection to a table in given Document. BookmarkName is the name of the bookmark associated
// with the table.
public static dynamic Export(string DocumentPath, string BookmarkName, int StartRow, bool BuildColumnHeadings, IVisualCollection collection, List <string> ColumnNames)
{
dynamic functionReturnValue = null;
List <ColumnMapping> mappings = new List <ColumnMapping>();
ColumnMapping map = default(ColumnMapping);
dynamic doc = null;
WordHelper wordProxy = new WordHelper();
FieldDefinition fd = default(FieldDefinition);
// if Word is active then use it
if (!wordProxy.GetWord())
{
if (!wordProxy.CreateWord())
{
throw new System.Exception("Could not start Microsoft Word.");
}
}
wordProxy.OpenDocument(DocumentPath);
doc = wordProxy.Document;
foreach (string name in ColumnNames)
{
fd = collection.GetFieldDefinition(name);
map = new ColumnMapping("", name);
if (fd == null)
{
map.TableField.DisplayName = name;
}
else
{
map.TableField = fd;
}
mappings.Add(map);
}
functionReturnValue = Export(doc, BookmarkName, StartRow, BuildColumnHeadings, collection, mappings);
wordProxy.ShowDocument();
return(functionReturnValue);
}
// Exports a collection to a table in given Document. BookmarkName is the name of the bookmark associated
// with the table.
public static dynamic Export(dynamic Document, string BookmarkName, int StartRow, bool BuildColumnHeadings, IVisualCollection collection, List <string> ColumnNames)
{
List <ColumnMapping> mappings = new List <ColumnMapping>();
ColumnMapping map = default(ColumnMapping);
FieldDefinition fd = default(FieldDefinition);
foreach (string name in ColumnNames)
{
fd = collection.GetFieldDefinition(name);
map = new ColumnMapping("", name);
if (fd == null)
{
map.TableField.DisplayName = name;
}
else
{
map.TableField = fd;
}
mappings.Add(map);
}
return(Export(Document, BookmarkName, StartRow, BuildColumnHeadings, collection, mappings));
}
// Imports a range starting at the location specified by workbook, worksheet, and range.
// Workbook should be the full path to the workbook.
public static void Import(IVisualCollection collection, string Workbook, string Worksheet, string Range, List <ColumnMapping> ColumnMapping)
{
_collection = collection;
_columnMappings = ColumnMapping;
// Ensure that we have the correct and complete field definition.
foreach (OfficeSharp.ColumnMapping map in _columnMappings)
{
map.TableField = collection.GetFieldDefinition(map.TableField.Name);
}
Dispatchers.Main.BeginInvoke(() =>
{
ExcelHelper xlProxy = new ExcelHelper();
dynamic wb = null;
dynamic ws = null;
dynamic rg = null;
wb = xlProxy.Excel.Workbooks.Open(Workbook);
if ((wb != null))
{
ws = wb.Worksheets(Worksheet);
if ((ws != null))
{
rg = ws.Range(Range);
_excelDocRange = ConvertToArray(rg);
ValidateData();
}
}
rg = null;
ws = null;
wb.Close(false);
wb = null;
xlProxy.Dispose();
});
}
// Exports a collection to a table in given Document. BookmarkName is the name of the bookmark associated
// with the table.
public static dynamic Export(dynamic Document, string BookmarkName, int StartRow, bool BuildColumnHeadings, IVisualCollection collection, List<string> ColumnNames)
{
List<ColumnMapping> mappings = new List<ColumnMapping>();
ColumnMapping map = default(ColumnMapping);
FieldDefinition fd = default(FieldDefinition);
foreach (string name in ColumnNames)
{
fd = collection.GetFieldDefinition(name);
map = new ColumnMapping("", name);
if (fd == null)
{
map.TableField.DisplayName = name;
}
else
{
map.TableField = fd;
}
mappings.Add(map);
}
return Export(Document, BookmarkName, StartRow, BuildColumnHeadings, collection, mappings);
}
// Exports a collection to a table in given Document. BookmarkName is the name of the bookmark associated
// with the table.
public static dynamic Export(string DocumentPath, string BookmarkName, int StartRow, bool BuildColumnHeadings, IVisualCollection collection, List<string> ColumnNames)
{
dynamic functionReturnValue = null;
List<ColumnMapping> mappings = new List<ColumnMapping>();
ColumnMapping map = default(ColumnMapping);
dynamic doc = null;
WordHelper wordProxy = new WordHelper();
FieldDefinition fd = default(FieldDefinition);
// if Word is active then use it
if (!wordProxy.GetWord())
{
if (!wordProxy.CreateWord())
{
throw new System.Exception("Could not start Microsoft Word.");
}
}
wordProxy.OpenDocument(DocumentPath);
doc = wordProxy.Document;
foreach (string name in ColumnNames)
{
fd = collection.GetFieldDefinition(name);
map = new ColumnMapping("", name);
if (fd == null)
{
map.TableField.DisplayName = name;
}
else
{
map.TableField = fd;
}
mappings.Add(map);
}
functionReturnValue = Export(doc, BookmarkName, StartRow, BuildColumnHeadings, collection, mappings);
wordProxy.ShowDocument();
return functionReturnValue;
}