public static XS__spreadsheet[] Load_fromURI(
XS__RootMetadata root_ref_in,
params Uri[] filePath_in
)
{
XS__spreadsheet[] _output
= new XS__spreadsheet[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++)
{
if (filePath_in[i].IsFile)
{
_output[i] = XS__spreadsheet.Load_fromFile(
filePath_in[i].LocalPath
)[0];
// no need! everything's been taken care at: XS__spreadsheet.Load_fromFile(...)
//_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
//_output[i].parent_ref = root_ref_in; // ToDos: now!
//if (root_ref_in != null) _output[i].root_ref = root_ref_in;
}
else
{
try {
_output[i] = (XS__spreadsheet) new XmlSerializer(typeof(XS__spreadsheet)).Deserialize(
OGen.Libraries.PresentationLayer.WebForms.Utilities.ReadURL(
filePath_in[i].ToString()
)
);
} catch (Exception _ex) {
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"\n---\n{0}.{1}.Load_fromURI():\nERROR READING XML:\n{2}\n---\n{3}",
typeof(XS__spreadsheet).Namespace,
typeof(XS__spreadsheet).Name,
//(filePath_in[i].IsFile)
// ? filePath_in[i].LocalPath
// :
filePath_in[i].ToString(),
_ex.Message
));
}
_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null)
{
_output[i].root_ref = root_ref_in;
}
}
}
return(_output);
}
public XS__RootMetadata(
#endif
string metadataFilePath_in
)
{
string _metadataPath = System.IO.Path.GetDirectoryName(metadataFilePath_in);
this.metadatafiles_ = Metadatas.Load_fromFile(metadataFilePath_in);
#region int _total_xxx = ...;
int _total_spreadsheet = 0;
for (int f = 0; f < this.metadatafiles_.MetadataFiles.Count; f++)
{
switch (this.metadatafiles_.MetadataFiles[f].XMLFileType)
{
case XS__spreadsheet.SPREADSHEET:
_total_spreadsheet++;
break;
}
}
#endregion
#region string[] _xxxFilePath = new string[_total_xxx];
string[] _spreadsheetFilePath = new string[
_total_spreadsheet
];
#endregion
_total_spreadsheet = 0;
for (int f = 0; f < this.metadatafiles_.MetadataFiles.Count; f++)
{
switch (this.metadatafiles_.MetadataFiles[f].XMLFileType)
{
case XS__spreadsheet.SPREADSHEET:
_spreadsheetFilePath[_total_spreadsheet] = System.IO.Path.Combine(
_metadataPath,
this.metadatafiles_.MetadataFiles[f].XMLFileName
);
_total_spreadsheet++;
break;
}
}
this.spreadsheetcollection_ = new XS__spreadsheetCollection(
XS__spreadsheet.Load_fromFile(
(XS__RootMetadata)this,
_spreadsheetFilePath
)
);
}
public static XS__spreadsheet[] Load_fromFile(
XS__RootMetadata root_ref_in,
params string[] filePath_in
)
{
FileStream _stream;
XS__spreadsheet[] _output
= new XS__spreadsheet[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++)
{
_stream = new FileStream(
filePath_in[i],
FileMode.Open,
FileAccess.Read,
FileShare.Read
);
try {
_output[i] = (XS__spreadsheet) new XmlSerializer(typeof(XS__spreadsheet)).Deserialize(
_stream
);
_stream.Close();
#if !NET_1_1
_stream.Dispose();
#endif
} catch (Exception _ex) {
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"\n---\n{0}.{1}.Load_fromFile():\nERROR READING XML:\n{2}\n---\n{3}\n---\n{4}\n---\n",
typeof(XS__spreadsheet).Namespace,
typeof(XS__spreadsheet).Name,
filePath_in[i],
_ex.Message,
_ex.InnerException
));
}
_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null)
{
_output[i].root_ref = root_ref_in;
}
}
return(_output);
}
public static XS__spreadsheet[] Load_fromFile(
XS__RootMetadata root_ref_in,
params string[] filePath_in
) {
FileStream _stream;
XS__spreadsheet[] _output
= new XS__spreadsheet[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++) {
_stream = new FileStream(
filePath_in[i],
FileMode.Open,
FileAccess.Read,
FileShare.Read
);
try {
_output[i] = (XS__spreadsheet)new XmlSerializer(typeof(XS__spreadsheet)).Deserialize(
_stream
);
_stream.Close();
#if !NET_1_1
_stream.Dispose();
#endif
} catch (Exception _ex) {
throw new Exception(string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"\n---\n{0}.{1}.Load_fromFile():\nERROR READING XML:\n{2}\n---\n{3}\n---\n{4}\n---\n",
typeof(XS__spreadsheet).Namespace,
typeof(XS__spreadsheet).Name,
filePath_in[i],
_ex.Message,
_ex.InnerException
));
}
_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null) _output[i].root_ref = root_ref_in;
}
return _output;
}
public XS__spreadsheetCollection(
#endif
XS__spreadsheet[] spreadsheetCollection_in
) {
this.spreadsheetcollection_ = spreadsheetCollection_in;
}
public static XS__spreadsheet[] Load_fromURI(
XS__RootMetadata root_ref_in,
params Uri[] filePath_in
) {
XS__spreadsheet[] _output
= new XS__spreadsheet[filePath_in.Length];
for (int i = 0; i < filePath_in.Length; i++) {
if (filePath_in[i].IsFile) {
_output[i] = XS__spreadsheet.Load_fromFile(
filePath_in[i].LocalPath
)[0];
// no need! everything's been taken care at: XS__spreadsheet.Load_fromFile(...)
//_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
//_output[i].parent_ref = root_ref_in; // ToDos: now!
//if (root_ref_in != null) _output[i].root_ref = root_ref_in;
} else {
try {
_output[i] = (XS__spreadsheet)new XmlSerializer(typeof(XS__spreadsheet)).Deserialize(
OGen.lib.presentationlayer.webforms.utils.ReadURL(
filePath_in[i].ToString()
)
);
} catch (Exception _ex) {
throw new Exception(string.Format(
"\n---\n{0}.{1}.Load_fromURI():\nERROR READING XML:\n{2}\n---\n{3}",
typeof(XS__spreadsheet).Namespace,
typeof(XS__spreadsheet).Name,
//(filePath_in[i].IsFile)
// ? filePath_in[i].LocalPath
// :
filePath_in[i].ToString(),
_ex.Message
));
}
_output[i].root_spreadsheet_ = ROOT + "." + SPREADSHEET + "[" + i + "]";
_output[i].parent_ref = root_ref_in; // ToDos: now!
if (root_ref_in != null) _output[i].root_ref = root_ref_in;
}
}
return _output;
}
public static XS__spreadsheet DataTable_toXMLSpreadsheet(
params DataTable[] dt_spreadsheet_in
) {
int _pageIndex;
int _rowIndex;
int _cellIndex;
XS__spreadsheet _ss_output = new XS__spreadsheet();
for (int s = 0; s < dt_spreadsheet_in.Length; s++) {
_ss_output.PageCollection.Add(
out _pageIndex,
new XS_pageType()
);
_ss_output.PageCollection[_pageIndex].Name = dt_spreadsheet_in[s].TableName;
_ss_output.PageCollection[_pageIndex].RowCollection.Add(
out _rowIndex,
new XS_rowType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].isHeader = true;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++) {
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection.Add(
out _cellIndex,
new XS_cellType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= dt_spreadsheet_in[s].Columns[c].Caption;
}
bool _isEmpty;
for (int r = 0; r < dt_spreadsheet_in[s].Rows.Count; r++) {
_isEmpty = true;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++) {
if (dt_spreadsheet_in[s].Rows[r][c] != DBNull.Value) {
_isEmpty = false;
}
}
if (_isEmpty) continue;
_ss_output.PageCollection[_pageIndex].RowCollection.Add(
out _rowIndex,
new XS_rowType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].isHeader = false;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++) {
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection.Add(
out _cellIndex,
new XS_cellType()
);
if (dt_spreadsheet_in[s].Rows[r][c] != DBNull.Value) {
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].isNull = false;
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= dt_spreadsheet_in[s].Rows[r][c].ToString();
} else {
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].isNull = true;
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= "";
}
}
}
}
return _ss_output;
}
public XS__spreadsheetCollection(
XS__spreadsheet[] spreadsheetcollection_in
) : base (
spreadsheetcollection_in
) {
}
public static XS__spreadsheet DataTable_toXMLSpreadsheet(
params DataTable[] dt_spreadsheet_in
)
{
int _pageIndex;
int _rowIndex;
int _cellIndex;
XS__spreadsheet _ss_output = new XS__spreadsheet();
for (int s = 0; s < dt_spreadsheet_in.Length; s++)
{
_ss_output.PageCollection.Add(
out _pageIndex,
new XS_pageType()
);
_ss_output.PageCollection[_pageIndex].Name = dt_spreadsheet_in[s].TableName;
_ss_output.PageCollection[_pageIndex].RowCollection.Add(
out _rowIndex,
new XS_rowType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].IsHeader = true;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++)
{
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection.Add(
out _cellIndex,
new XS_cellType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= dt_spreadsheet_in[s].Columns[c].Caption;
}
bool _isEmpty;
for (int r = 0; r < dt_spreadsheet_in[s].Rows.Count; r++)
{
_isEmpty = true;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++)
{
if (dt_spreadsheet_in[s].Rows[r][c] != DBNull.Value)
{
_isEmpty = false;
}
}
if (_isEmpty)
{
continue;
}
_ss_output.PageCollection[_pageIndex].RowCollection.Add(
out _rowIndex,
new XS_rowType()
);
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].IsHeader = false;
for (int c = 0; c < dt_spreadsheet_in[s].Columns.Count; c++)
{
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection.Add(
out _cellIndex,
new XS_cellType()
);
if (dt_spreadsheet_in[s].Rows[r][c] != DBNull.Value)
{
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].IsNull = false;
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= dt_spreadsheet_in[s].Rows[r][c].ToString();
}
else
{
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].IsNull = true;
_ss_output.PageCollection[_pageIndex].RowCollection[_rowIndex].CellCollection[_cellIndex].Data
= "";
}
}
}
}
return(_ss_output);
}
public static void Main(string[] args)
{
#region string _ssFilePath = args[0];
string _spreadSheetFilePath;
#if DEBUG
if (args.Length != 1)
{
_spreadSheetFilePath = @"C:\Documents and Settings\Administrator\Desktop\TEST\Livro1.xlsx";
}
else
{
_spreadSheetFilePath = args[0];
}
#else
if (
(args.Length != 1)
)
{
Console.WriteLine("invalid argument!");
}
_ssFilePath = args[0];
if (
!System.IO.File.Exists(_ssFilePath)
)
{
Console.WriteLine("file not found!");
}
#endif
#endregion
#region DataTable[] _datatable = XS__spreadsheet.Spreadsheet_toDataTable(...);
DataTable[] _datatable = XS__spreadsheet.Spreadsheet_toDataTable(
_spreadSheetFilePath
);
if (_datatable == null)
{
return;
}
#endregion
#region string _xmlFilePath = ...;
string _xmlFilePath = System.IO.Path.Combine(
System.IO.Path.GetDirectoryName(_spreadSheetFilePath),
string.Format(
System.Globalization.CultureInfo.CurrentCulture,
"{0}.SpreadsheetXML.xml",
System.IO.Path.GetFileNameWithoutExtension(_spreadSheetFilePath)
)
);
#endregion
XS__spreadsheet.DataTable_toXMLSpreadsheet(
_datatable
).SaveState_toFile(
_xmlFilePath
);
#if DEBUG
XS__spreadsheet _ss = XS__spreadsheet.Load_fromFile(
_xmlFilePath
)[0];
for (int p = 0; p < _ss.PageCollection.Count; p++)
{
Console.WriteLine("--- {0}", _ss.PageCollection[p].Name);
for (int r = 0; r < _ss.PageCollection[p].RowCollection.Count; r++)
{
for (int c = 0; c < _ss.PageCollection[p].RowCollection[r].CellCollection.Count; c++)
{
Console.Write("{0}\t", _ss.PageCollection[p].RowCollection[r].CellCollection[c].Data);
}
Console.WriteLine();
}
Console.WriteLine();
}
#endif
}
