Displaying items by tag: edit

Thursday, 16 December 2010 06:35

How to Edit a Word Document

If you want to edit an existing word document, you should open it first. So, you need to know How to Open a Word Document at first.

To edit a paragraph, you need to reference a Spire.Doc.Documents.Paragraph object which represents the physical paragraph which you want to edit. In this demo, I will edit the second pragraph of the first section of my word document, we suppose I have opened it and reference it via variable document.

[C#]

Section section = document.Sections[0];
Paragraph paragraph = section.Paragraphs[1];

[Visual Basic]

Dim section As Section = document.Sections(0)
Dim paragraph As Paragraph = section.Paragraphs(1)

Now, we can edit it as we want.

[C#]

//update the original text
paragraph.Text = "Updated";

 //append a new text
paragraph.AppendText(" by Spire.Doc.");

[Visual Basic]

'update the original text
paragraph.Text = "Updated"

 'append a new text
paragraph.AppendText(" by Spire.Doc.")

Full example

[C#]

//open the word document
Document document = new Document("Editing.doc");

 //get the paragraph which we want to edit
Section section = document.Sections[0];
Paragraph paragraph = section.Paragraphs[1];

 //update the original text
paragraph.Text = "Updated";

 //append a new text
paragraph.AppendText(" by Spire.Doc.");

 //save to a file
document.SaveToFile("Sample.doc");

[Visual Basic]

'open the word document
Dim document As New Document("Editing.doc")

 'get the paragraph which we want to edit
Dim section As Section = document.Sections(0)
Dim paragraph As Paragraph = section.Paragraphs(1)

 'update the original text
paragraph.Text = "Updated"

 'append a new text
paragraph.AppendText(" by Spire.Doc.")

 'save to a file
document.SaveToFile("Sample.doc")

(Back to content)

Published in Program Guide

Wednesday, 21 July 2010 06:49

The sample demonstrates how to edit a Word document.

  private void button1_Click(object sender, EventArgs e)
{
    //Create word document
    Document document = new Document();
    document.LoadFromFile(@"..\..\..\..\..\..\Data\Editing.doc");

    //Get a paragraph
    Paragraph paragraph = document.Sections[0].AddParagraph();

    //Append Text
    paragraph.AppendText("Editing sample");

    //Save doc file.
    document.SaveToFile("Sample.doc", FileFormat.Doc);

    //Launching the MS Word file.
    WordDocViewer("Sample.doc");
}

private void WordDocViewer(string fileName)
{
    try
    {
        System.Diagnostics.Process.Start(fileName);
    }
    catch { }
}

    Private Sub button1_Click(ByVal sender As Object, ByVal e As EventArgs) Handles button1.Click
	'Create word document
	Dim document_Renamed As New Document()
	document_Renamed.LoadFromFile("..\..\..\..\..\..\Data\Editing.doc")

	'Get a paragraph
	Dim paragraph_Renamed As Paragraph = document_Renamed.Sections(0).AddParagraph()

	'Append Text
	paragraph_Renamed.AppendText("Editing sample")

	'Save doc file.
	document_Renamed.SaveToFile("Sample.doc", FileFormat.Doc)

	'Launching the MS Word file.
	WordDocViewer("Sample.doc")
End Sub

Private Sub WordDocViewer(ByVal fileName As String)
	Try
		Process.Start(fileName)
	Catch
	End Try
End Sub

Published in Quick guide

Saturday, 03 July 2010 00:40

EXCEL Edit Chart Sheet for C#, VB.NET

Demo
C# source
VB.Net source

The sample demonstrates how to edit chart worksheet in an excel workbook.

		private void btnRun_Click(object sender, System.EventArgs e)
		{
			Workbook workbook = new Workbook();
  			
			//Initialize worksheet
			workbook.LoadFromFile("../../../../../../Data/EditChartSample.xls",true);
			Worksheet sheet = workbook.Worksheets[0];

			//Writes chart data
			CreateChartData(sheet);

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void CreateChartData(Worksheet sheet)
		{
			//Jun
			sheet.Range["F6"].NumberValue = 6000;
			sheet.Range["F7"].NumberValue = 8000;
			sheet.Range["F8"].NumberValue = 9000;
			sheet.Range["F9"].NumberValue = 8500;

			//Aug
			sheet.Range["G6"].NumberValue = 4000;
			sheet.Range["G7"].NumberValue = 7000;
			sheet.Range["G8"].NumberValue = 2000;
			sheet.Range["G9"].NumberValue = 5000;

			sheet.Range["F6:F9"].Style.NumberFormat = "\"$\"#,##0";
			sheet.Range["G6:G9"].Style.NumberFormat = "\"$\"#,##0";
		}

		private void ExcelDocViewer( string fileName )
		{
			try
			{
				System.Diagnostics.Process.Start(fileName);
			}
			catch{}
		}

		Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click
			Dim workbook As Workbook = New Workbook()

			'Initialize worksheet
			workbook.LoadFromFile("../../../../../../Data/EditChartSample.xls",True)
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'Writes chart data
			CreateChartData(sheet)

			workbook.SaveToFile("Sample.xls")
			ExcelDocViewer(workbook.FileName)
		End Sub

		Private Sub CreateChartData(ByVal sheet As Worksheet)
			'Jun
			sheet.Range("F6").NumberValue = 6000
			sheet.Range("F7").NumberValue = 8000
			sheet.Range("F8").NumberValue = 9000
			sheet.Range("F9").NumberValue = 8500

			'Aug
			sheet.Range("G6").NumberValue = 4000
			sheet.Range("G7").NumberValue = 7000
			sheet.Range("G8").NumberValue = 2000
			sheet.Range("G9").NumberValue = 5000

			sheet.Range("F6:F9").Style.NumberFormat = """$""#,##0"
			sheet.Range("G6:G9").Style.NumberFormat = """$""#,##0"
		End Sub

		Private Sub ExcelDocViewer(ByVal fileName As String)
			Try
				System.Diagnostics.Process.Start(fileName)
			Catch
			End Try
		End Sub

Published in Charts

Friday, 02 July 2010 14:01

EXCEL Edit Sheet for C#, VB.NET

Demo
C# source
VB.Net source

The sample demonstrates how to edit a worksheet in an excel workbook.

       private void btnRun_Click(object sender, System.EventArgs e)
		{
			
			Workbook workbook = new Workbook();
			
			//Load workbook from disk.
			workbook.LoadFromFile(@"..\..\..\..\..\..\Data\EditSheetSample.xls");
			//Initialize worksheet
			Worksheet sheet = workbook.Worksheets[0];

			//Writes string
			sheet.Range["B1"].Text = "Hello,World!";
			//Writes number
			sheet.Range["B2"].NumberValue = 1234.5678;
			//Writes date
			sheet.Range["B3"].DateTimeValue = System.DateTime.Now;
			//Writes formula
			sheet.Range["B4"].Formula = "=1111*11111";

			workbook.SaveToFile("Sample.xls");
			ExcelDocViewer(workbook.FileName);
		}

		private void ExcelDocViewer( string fileName )
		{
			try
			{
				System.Diagnostics.Process.Start(fileName);
			}
			catch{}
		}

          Private Sub btnRun_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnRun.Click

			Dim workbook As Workbook = New Workbook()

			'Load workbook from disk.
			workbook.LoadFromFile("..\..\..\..\..\..\Data\EditSheetSample.xls")
			'Initialize worksheet
			Dim sheet As Worksheet = workbook.Worksheets(0)

			'Writes string
			sheet.Range("B1").Text = "Hello,World!"
			'Writes number
			sheet.Range("B2").NumberValue = 1234.5678
			'Writes date
			sheet.Range("B3").DateTimeValue = System.DateTime.Now
			'Writes formula
			sheet.Range("B4").Formula = "=1111*11111"

			workbook.SaveToFile("Sample.xls")
			ExcelDocViewer(workbook.FileName)
		End Sub

		Private Sub ExcelDocViewer(ByVal fileName As String)
			Try
				System.Diagnostics.Process.Start(fileName)
			Catch
			End Try
		End Sub

Published in Quick guide