public short NewWorksheet(string name = "")
{
try {
System.Resources.ResourceManager resourceManager =
new System.Resources.ResourceManager("fastxcel.Resource", GetType().Assembly);
var assembly = System.Reflection.Assembly.GetExecutingAssembly();
short new_ws_number = (short)(Worksheets.Count + 1);
string res_id = "Re";
Worksheet new_wrk = new Worksheet(shared_strings);
if (name == String.Empty)
{
name = "Worksheet" + Worksheets.Count.ToString();
}
// First of all - create new xml file
int num = 1;
while (File.Exists(temp_path + "\\xl\\worksheets\\sheet" + num.ToString() + ".xml"))
{
++num;
}
string new_file_path = temp_path + "\\xl\\worksheets\\sheet" + num.ToString() + ".xml";
string resource_path = assembly.GetName().Name + ".Resources.sheet_xml";
BinaryReader br = new BinaryReader(assembly.GetManifestResourceStream(resource_path));
long file_length = assembly.GetManifestResourceStream(resource_path).Length;
byte[] inners = new byte[file_length];
inners = br.ReadBytes((int)file_length);
br.Close();
FileStream fs = File.Create(new_file_path);
BinaryWriter bw = new BinaryWriter(fs);
bw.Write(inners);
bw.Close();
// Register relationship
int res_id_num = xml_wb_rels.XmlElements.Count;
AddNewRelationship(num, "rId" + res_id_num.ToString(), "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet");
// Add into workbook.xml
AddSheetInWorkbook("rId" + res_id_num.ToString(), name, new_ws_number);
// Finally
new_wrk.Load(new_file_path, shared_strings);
Worksheets.Add(new_wrk);
return(new_ws_number);
} catch (Exception ex) {
throw new FastXcelException("Can't create new worksheet" + ex.Message, ex);
}
}
private void ProcessWorksheets()
{
try {
Worksheets.Clear();
string[] xl_sheet_files = Directory.GetFiles(temp_path + "\\xl\\worksheets\\", "sheet*.xml");
foreach (string sheet_file in xl_sheet_files)
{
string res_id = GetResourceId(sheet_file);
string name = GetWorksheetName(sheet_file, res_id);
short sheet_id = GetWorksheetId(sheet_file, res_id);
Console.WriteLine("---------------------------" + sheet_file + "-------------------------------------");
Worksheet wrk = new Worksheet(shared_strings);
wrk.Load(res_id, sheet_id, name, sheet_file, shared_strings);
wrk.Number = (uint)Worksheets.Count;
Console.WriteLine("---------------------------------------------------------------------------------------");
Worksheets.Add(wrk);
}
} catch (Exception ex) {
throw new FastXcelException("Error processing worksheets", ex);
}
}
private void ProcessWorksheets()
{
try {
Worksheets.Clear();
string[] xl_sheet_files = Directory.GetFiles(temp_path+"\\xl\\worksheets\\", "sheet*.xml");
foreach ( string sheet_file in xl_sheet_files ) {
string res_id = GetResourceId(sheet_file);
string name = GetWorksheetName(sheet_file, res_id);
short sheet_id = GetWorksheetId(sheet_file, res_id);
Console.WriteLine("---------------------------"+ sheet_file +"-------------------------------------");
Worksheet wrk = new Worksheet( shared_strings );
wrk.Load( res_id, sheet_id, name, sheet_file, shared_strings );
wrk.Number = (uint)Worksheets.Count;
Console.WriteLine("---------------------------------------------------------------------------------------");
Worksheets.Add( wrk );
}
} catch ( Exception ex ) {
throw new FastXcelException( "Error processing worksheets", ex );
}
}
public short NewWorksheet( string name = "" )
{
try {
System.Resources.ResourceManager resourceManager =
new System.Resources.ResourceManager("fastxcel.Resource", GetType().Assembly);
var assembly = System.Reflection.Assembly.GetExecutingAssembly();
short new_ws_number = (short)(Worksheets.Count+1);
string res_id = "Re";
Worksheet new_wrk = new Worksheet( shared_strings );
if ( name == String.Empty )
name = "Worksheet"+Worksheets.Count.ToString();
// First of all - create new xml file
int num = 1;
while ( File.Exists(temp_path+"\\xl\\worksheets\\sheet"+num.ToString()+".xml") )
++num;
string new_file_path = temp_path+"\\xl\\worksheets\\sheet"+num.ToString()+".xml";
string resource_path = assembly.GetName().Name+".Resources.sheet_xml";
BinaryReader br = new BinaryReader(assembly.GetManifestResourceStream(resource_path));
long file_length = assembly.GetManifestResourceStream(resource_path).Length;
byte[] inners = new byte[file_length];
inners = br.ReadBytes((int)file_length);
br.Close();
FileStream fs = File.Create( new_file_path );
BinaryWriter bw = new BinaryWriter( fs );
bw.Write(inners);
bw.Close();
// Register relationship
int res_id_num = xml_wb_rels.XmlElements.Count;
AddNewRelationship(num, "rId" + res_id_num.ToString(), "http://schemas.openxmlformats.org/officeDocument/2006/relationships/worksheet");
// Add into workbook.xml
AddSheetInWorkbook( "rId" + res_id_num.ToString(), name, new_ws_number );
// Finally
new_wrk.Load( new_file_path, shared_strings );
Worksheets.Add( new_wrk );
return new_ws_number;
} catch ( Exception ex ) {
throw new FastXcelException( "Can't create new worksheet"+ex.Message, ex );
}
}
