private void newNToolStripMenuItem_Click(object sender, EventArgs e) { //test create xls file string file = "C:\\newdoc.xls"; Workbook workbook = new Workbook(); Worksheet worksheet = new Worksheet("First Sheet"); worksheet.Cells[0, 1] = new Cell((short)1); worksheet.Cells[2, 0] = new Cell(2.8); worksheet.Cells[3, 3] = new Cell((decimal)3.45); worksheet.Cells[2, 2] = new Cell("Text string"); worksheet.Cells[2, 4] = new Cell("Second string"); worksheet.Cells[4, 0] = new Cell(32764.5, "#,##0.00"); worksheet.Cells[5, 1] = new Cell(DateTime.Now, @"YYYY\-MM\-DD"); worksheet.Cells.ColumnWidth[0, 1] = 3000; //Picture pic = new Picture(); //pic.Image = Excel.Image.FromFile("C:\\DelBreakpoint.png"); //pic.TopLeftCorner = new CellAnchor(5, 1, 0, 0); //pic.BottomRightCorner = new CellAnchor(12, 5, 592, 243); //worksheet.AddPicture(pic); workbook.Worksheets.Add(worksheet); workbook.Save(file); //open created file doc = CompoundDocument.Open(file); IsOpened = true; PopulateTreeview(file); }
public MasterSectorAllocation(CompoundDocument document) { this.Document = document; this.NumberOfSecIDs = document.Header.NumberOfSATSectors; this.CurrentMSATSector = document.Header.FirstSectorIDofMasterSectorAllocationTable; this.SecIDCapacity = document.SectorSize / 4 - 1; InitializeMasterSectorAllocationTable(); }
public static CompoundDocument Create(Stream stream) { CompoundDocument document = new CompoundDocument(stream, new CompoundFileHeader()); document.WriteHeader(); document.MasterSectorAllocation.AllocateSATSector(); document.InitializeDirectoryEntries(); return document; }
public static CompoundDocument Create(string file) { FileStream stream = File.Open(file, FileMode.Create, FileAccess.ReadWrite, FileShare.Read); CompoundDocument document = new CompoundDocument(stream, new CompoundFileHeader()); document.WriteHeader(); document.MasterSectorAllocation.AllocateSATSector(); document.InitializeDirectoryEntries(); return document; }
public ShortSectorAllocation(CompoundDocument document) { this.Document = document; ShortSectorAllocationTable = document.GetStreamDataAsIntegers(document.Header.FirstSectorIDofShortSectorAllocationTable); //ShortSectorAllocationTable.RemoveRange(document.Header.NumberOfShortSectors, ShortSectorAllocationTable.Count - document.Header.NumberOfShortSectors); while (ShortSectorAllocationTable.Count > 0 && ShortSectorAllocationTable[ShortSectorAllocationTable.Count - 1] == SID.Free) { ShortSectorAllocationTable.RemoveAt(ShortSectorAllocationTable.Count - 1); } }
public static CompoundDocument Open(Stream stream) { BinaryReader reader = new BinaryReader(stream); FileHeader header = ReadHeader(reader); CompoundDocument document = new CompoundDocument(stream, header); if (!document.CheckHeader()) return null; document.ReadDirectoryEntries(); return document; }
public static CompoundDocument Open(string file) { FileStream stream = File.Open(file, FileMode.Open, FileAccess.ReadWrite, FileShare.Read); BinaryReader reader = new BinaryReader(stream); FileHeader header = ReadHeader(reader); CompoundDocument document = new CompoundDocument(stream, header); if (!document.CheckHeader()) return null; document.ReadDirectoryEntries(); return document; }
private void openOToolStripMenuItem_Click(object sender, EventArgs e) { try { string xlsfilter = "Excel files(*.xls)|*.xls|All files (*.*)|*.*"; string file = FileSelector.BrowseFile(xlsfilter); if (file == null) return; doc = CompoundDocument.Open(file); IsOpened = true; PopulateTreeview(file); } catch (Exception error) { MessageBox.Show(error.Message); } }
public static CompoundDocument Open(string file) { FileStream fileStream = File.Open(file, FileMode.Open, FileAccess.ReadWrite, FileShare.Read); BinaryReader reader = new BinaryReader(fileStream); FileHeader header = CompoundDocument.ReadHeader(reader); CompoundDocument compoundDocument = new CompoundDocument(fileStream, header); CompoundDocument result; if (!compoundDocument.CheckHeader()) { result = null; } else { compoundDocument.ReadDirectoryEntries(); result = compoundDocument; } return(result); }
public void Save() { if (ShortSectorAllocationTable.Count > 0) { if (Document.Header.FirstSectorIDofShortSectorAllocationTable == SID.EOC) { int SecIDCapacity = Document.SectorSize / 4; int[] sids = new Int32[SecIDCapacity]; for (int i = 0; i < sids.Length; i++) { sids[i] = SID.Free; } Document.Header.FirstSectorIDofShortSectorAllocationTable = Document.AllocateDataSector(); Document.WriteInSector(Document.Header.FirstSectorIDofShortSectorAllocationTable, 0, sids); } MemoryStream satStream = new MemoryStream(ShortSectorAllocationTable.Count * 4); CompoundDocument.WriteArrayOfInt32(new BinaryWriter(satStream), ShortSectorAllocationTable.ToArray()); Document.WriteStreamData(Document.Header.FirstSectorIDofShortSectorAllocationTable, satStream.ToArray()); } }
private static void WriteHeader(BinaryWriter writer, FileHeader header) { writer.Write(header.FileTypeIdentifier); writer.Write(header.FileIdentifier.ToByteArray()); writer.Write(header.RevisionNumber); writer.Write(header.VersionNumber); writer.Write(header.ByteOrderMark); writer.Write(header.SectorSizeInPot); writer.Write(header.ShortSectorSizeInPot); writer.Write(header.UnUsed10); writer.Write(header.NumberOfSATSectors); writer.Write(header.FirstSectorIDofDirectoryStream); writer.Write(header.UnUsed4); writer.Write(header.MinimumStreamSize); writer.Write(header.FirstSectorIDofShortSectorAllocationTable); writer.Write(header.NumberOfShortSectors); writer.Write(header.FirstSectorIDofMasterSectorAllocationTable); writer.Write(header.NumberOfMasterSectors); CompoundDocument.WriteArrayOfInt32(writer, header.MasterSectorAllocationTable); }
public void Save() { checked { if (this.ShortSectorAllocationTable.Count > 0) { if (this.Document.Header.FirstSectorIDofShortSectorAllocationTable == -2) { int num = this.Document.SectorSize / 4; int[] array = new int[num]; for (int i = 0; i < array.Length; i++) { array[i] = -1; } this.Document.Header.FirstSectorIDofShortSectorAllocationTable = this.Document.AllocateDataSector(); this.Document.WriteInSector(this.Document.Header.FirstSectorIDofShortSectorAllocationTable, 0, array); } MemoryStream memoryStream = new MemoryStream(this.ShortSectorAllocationTable.Count * 4); CompoundDocument.WriteArrayOfInt32(new BinaryWriter(memoryStream), this.ShortSectorAllocationTable.ToArray()); this.Document.WriteStreamData(this.Document.Header.FirstSectorIDofShortSectorAllocationTable, memoryStream.ToArray()); } } }
private static FileHeader ReadHeader(BinaryReader reader) { return(new FileHeader { FileTypeIdentifier = reader.ReadBytes(8), FileIdentifier = new Guid(reader.ReadBytes(16)), RevisionNumber = reader.ReadUInt16(), VersionNumber = reader.ReadUInt16(), ByteOrderMark = reader.ReadBytes(2), SectorSizeInPot = reader.ReadUInt16(), ShortSectorSizeInPot = reader.ReadUInt16(), UnUsed10 = reader.ReadBytes(10), NumberOfSATSectors = reader.ReadInt32(), FirstSectorIDofDirectoryStream = reader.ReadInt32(), UnUsed4 = reader.ReadBytes(4), MinimumStreamSize = reader.ReadInt32(), FirstSectorIDofShortSectorAllocationTable = reader.ReadInt32(), NumberOfShortSectors = reader.ReadInt32(), FirstSectorIDofMasterSectorAllocationTable = reader.ReadInt32(), NumberOfMasterSectors = reader.ReadInt32(), MasterSectorAllocationTable = CompoundDocument.ReadArrayOfInt32(reader, 109) }); }
public SectorAllocation(CompoundDocument document) { this.Document = document; this.SecIDCapacity = document.SectorSize / 4; }
public DirectoryEntry(CompoundDocument document, string name) : this(name) { Document = document; }
private void WriteHeader() { this.FileStorage.Position = 0L; CompoundDocument.WriteHeader(this.Writer, this.Header); }
private void _treeViewProjectExplore_DoubleClick(object sender, EventArgs e) { tabControl1X.SelectedIndex = 2; if (_treeViewProjectExplore.SelectedNode.Name == "File") { try { LoadExcelSheets(); } catch (Exception ex) { System.Windows.Forms.MessageBox.Show("Error opening the excel file." + Environment.NewLine + ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); } } //Open file excel string fName = _treeViewProjectExplore.Nodes[0].Tag + @"\" + _treeViewProjectExplore.Nodes[0].Nodes[0].Text + @"\" + _treeViewProjectExplore.SelectedNode.Text; string fName1 = _treeViewProjectExplore.Nodes[0].Tag + @"\" + _treeViewProjectExplore.Nodes[0].Nodes[1].Text + @"\" + _treeViewProjectExplore.SelectedNode.Text; string fName2 = _treeViewProjectExplore.Nodes[0].Tag + @"\" + _treeViewProjectExplore.Nodes[0].Nodes[2].Text + @"\" + _treeViewProjectExplore.SelectedNode.Text; if (_treeViewProjectExplore.SelectedNode.Text == _treeViewProjectExplore.SelectedNode.Text) { try { doc = CompoundDocument.Open(fName); LoadExcelSheets(); } catch (Exception ex) { } if (_treeViewProjectExplore.SelectedNode.Text == _treeViewProjectExplore.SelectedNode.Text) { try { doc = CompoundDocument.Open(fName1); LoadExcelSheets(); } catch (Exception ex) { } } if (_treeViewProjectExplore.SelectedNode.Text == _treeViewProjectExplore.SelectedNode.Text) { try { doc = CompoundDocument.Open(fName2); LoadExcelSheets(); } catch (Exception ex) { } } } }
private void addFileToolStripMenuItem_Click(object sender, EventArgs e) { _frmNewFile newFile = new _frmNewFile(); newFile.ShowDialog(); Excel.Application xlApp = default(Excel.Application); Excel.Workbook xlWorkBook = default(Excel.Workbook); Excel.Worksheet xlWorkSheet = default(Excel.Worksheet); TreeNode treeNode = new TreeNode(); treeNode.Text = newFile.textBoxName.Text + "." + newFile.comboBoxType.Text; treeNode.Tag = treeNode.Text; treeNode.Name = "File"; treeNode.ImageIndex = newFile.comboBoxType.SelectedIndex; newFile.Close(); if (newFile.textBoxName.Text != "") { _treeViewProjectExplore.SelectedNode.Nodes.Add(treeNode); _treeViewProjectExplore.SelectedNode.ExpandAll(); string fName = _treeViewProjectExplore.Nodes[0].Tag + @"\" + _treeViewProjectExplore.SelectedNode.Tag + @"\" + treeNode.Tag; try { object misValue = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkBook.SaveAs(fName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } finally { if (xlApp != null) releaseObject(xlApp); if (xlWorkBook != null) releaseObject(xlWorkBook); if (xlWorkSheet != null) releaseObject(xlWorkSheet); } if (System.IO.File.Exists(fName)) { //if (System.Windows.Forms.MessageBox.Show("Would you like to open the excel file?", this.Text, MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes) //{ // try // { // //System.Diagnostics.Process.Start(fName); doc = CompoundDocument.Open(fName); // LoadExcel(); // } // catch (Exception ex) // { // System.Windows.Forms.MessageBox.Show("Error opening the excel file." + Environment.NewLine + // ex.Message, this.Text, MessageBoxButtons.OK, MessageBoxIcon.Error); // } //} //doc1 = CompoundDocument.Open(fName); } } }
//------------------------------------------------------------------------------------ public string getopen(string path) { try { string file = path; doc = CompoundDocument.Open(file); return file; } catch(Exception e) { return ""; MessageBox.Show(""+ e); } }
private void addFileToolStripMenuItem_Click(object sender, EventArgs e) { _frmNewFile newFile = new _frmNewFile(); newFile.Text = _treeViewProjectExplore.SelectedNode.Text + " - " + newFile.Text; newFile.ShowDialog(); Excel.Application xlApp = default(Excel.Application); Excel.Workbook xlWorkBook = default(Excel.Workbook); //TabPage sheetPage = new TabPage(_treeViewProjectExplore.SelectedNode.Text); //Excel.Worksheet xlWorkSheet = default(Excel.Worksheet); Excel.Worksheet xlWorkSheet = new Excel.Worksheet(); TreeNode treeNode = new TreeNode(); treeNode.Text = newFile.textBoxName.Text + "." + newFile.comboBoxType.Text; treeNode.Tag = treeNode.Text; treeNode.Name = "File"; treeNode.ImageIndex = newFile.comboBoxType.SelectedIndex; newFile.Close(); if (newFile.textBoxName.Text != "") { _treeViewProjectExplore.SelectedNode.Nodes.Add(treeNode); _treeViewProjectExplore.SelectedNode.ExpandAll(); string fName = _treeViewProjectExplore.Nodes[0].Tag + @"\" + _treeViewProjectExplore.SelectedNode.Tag + @"\" + treeNode.Tag; try { object misValue = System.Reflection.Missing.Value; xlApp = new Excel.Application(); xlWorkBook = xlApp.Workbooks.Add(misValue); xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1); xlWorkBook.SaveAs(fName, Excel.XlFileFormat.xlWorkbookNormal, misValue, misValue, misValue, misValue, Excel.XlSaveAsAccessMode.xlExclusive, misValue, misValue, misValue, misValue, misValue); xlWorkBook.Close(true, misValue, misValue); xlApp.Quit(); releaseObject(xlWorkSheet); releaseObject(xlWorkBook); releaseObject(xlApp); } finally { if (xlApp != null) releaseObject(xlApp); if (xlWorkBook != null) releaseObject(xlWorkBook); if (xlWorkSheet != null) releaseObject(xlWorkSheet); } if (System.IO.File.Exists(fName)) { doc = CompoundDocument.Open(fName); } } }
public SectorAllocation(CompoundDocument document) { this.Document = document; this.SecIDCapacity = document.SectorSize / 4; }