C#/VB.NET: Converti Word in Excel
Installato tramite NuGet
PM> Install-Package Spire.Office
Link correlati
Word ed Excel sono due tipi di file completamente diversi. I documenti Word vengono utilizzati per scrivere saggi, lettere o creare report, mentre i documenti Excel vengono utilizzati per salvare i dati in forma tabellare, creare grafici o eseguire calcoli matematici. Non è consigliabile convertire un documento Word complesso in un foglio di calcolo Excel perché Excel difficilmente può eseguire il rendering del contenuto in base al layout originale in Word.
Tuttavia, se il documento Word è composto principalmente da tabelle e si desidera analizzare i dati della tabella in Excel, è possibile utilizzare Spire.Office for .NET per convertire Word in Excel Mentre mantenendo una buona leggibilità.
Installa Spire.Office for .NET
Per cominciare, è necessario aggiungere i file DLL inclusi nel pacchetto Spire.Office for .NET come riferimenti nel progetto .NET. I file DLL possono essere scaricati da questo link o installato tramite NuGet.
PM> Install-Package Spire.Office
Converti Word in Excel in C# e VB.NET
Questo scenario utilizza effettivamente due librerie nel pacchetto Spire.Office. Sono Spire.Doc for .NET e Spire.XLS for .NET. Il primo viene utilizzato per leggere ed estrarre il contenuto da un documento Word e il secondo viene utilizzato per creare un documento Excel e scrivere dati nelle celle specifiche. Per semplificare la comprensione di questo esempio di codice, abbiamo creato i seguenti tre metodi personalizzati che preformano funzioni specifiche.
- ExportTableInExcel(): esporta i dati da una tabella di Word alle celle di Excel specificate.
- CopyContentInTable() - Copia il contenuto da una cella di tabella in Word a una cella di Excel.
- CopyTextAndStyle() - Copia il testo con la formattazione da un paragrafo di Word a una cella di Excel.
I seguenti passaggi mostrano come esportare i dati da un intero documento di Word in un foglio di lavoro utilizzando Spire.Office for .NET.
- Crea un oggetto Document per caricare un file Word.
- Crea un oggetto Worbbook e aggiungi un foglio di lavoro denominato "WordToExcel".
- Attraversa tutte le sezioni nel documento di Word, attraversa tutti gli oggetti documento in una determinata sezione e quindi determina se un oggetto documento è un paragrafo o una tabella.
- Se l'oggetto documento è un paragrafo, scrivere il paragrafo in una cella specificata in Excel utilizzando il metodo CoypTextAndStyle().
- Se l'oggetto documento è una tabella, esportare i dati della tabella dalle celle di Word alle celle di Excel utilizzando il metodo ExportTableInExcel().
- Adatta automaticamente l'altezza della riga e la larghezza della colonna in Excel in modo che i dati all'interno di una cella non superino il limite della cella.
- Salvare la cartella di lavoro in un file Excel utilizzando il metodo Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using Spire.Xls;
using System;
using System.Drawing;
namespace ConvertWordToExcel
{
class Program
{
static void Main(string[] args)
{
//Create a Document object
Document doc = new Document();
//Load a Word file
doc.LoadFromFile(@"C:\Users\Administrator\Desktop\Invoice.docx");
//Create a Workbook object
Workbook wb = new Workbook();
//Remove the default worksheets
wb.Worksheets.Clear();
//Create a worksheet named "WordToExcel"
Worksheet worksheet = wb.CreateEmptySheet("WordToExcel");
int row = 1;
int column = 1;
//Loop through the sections in the Word document
foreach (Section section in doc.Sections)
{
//Loop through the document object under a certain section
foreach (DocumentObject documentObject in section.Body.ChildObjects)
{
//Determine if the object is a paragraph
if (documentObject is Paragraph)
{
CellRange cell = worksheet.Range[row, column];
Paragraph paragraph = documentObject as Paragraph;
//Copy paragraph from Word to a specific cell
CopyTextAndStyle(cell, paragraph);
row++;
}
//Determine if the object is a table
if (documentObject is Table)
{
Table table = documentObject as Table;
//Export table data from Word to Excel
int currentRow = ExportTableInExcel(worksheet, row, table);
row = currentRow;
}
}
}
//Auto fit row height and column width
worksheet.AllocatedRange.AutoFitRows();
worksheet.AllocatedRange.AutoFitColumns();
//Wrap text in cells
worksheet.AllocatedRange.IsWrapText = true;
//Save the workbook to an Excel file
wb.SaveToFile("WordToExcel.xlsx", ExcelVersion.Version2013);
}
//Export data from Word table to Excel cells
private static int ExportTableInExcel(Worksheet worksheet, int row, Table table)
{
CellRange cell;
int column;
foreach (TableRow tbRow in table.Rows)
{
column = 1;
foreach (TableCell tbCell in tbRow.Cells)
{
cell = worksheet.Range[row, column];
cell.BorderAround(LineStyleType.Thin, Color.Black);
CopyContentInTable(tbCell, cell);
column++;
}
row++;
}
return row;
}
//Copy content from a Word table cell to an Excel cell
private static void CopyContentInTable(TableCell tbCell, CellRange cell)
{
Paragraph newPara = new Paragraph(tbCell.Document);
for (int i = 0; i < tbCell.ChildObjects.Count; i++)
{
DocumentObject documentObject = tbCell.ChildObjects[i];
if (documentObject is Paragraph)
{
Paragraph paragraph = documentObject as Paragraph;
foreach (DocumentObject cObj in paragraph.ChildObjects)
{
newPara.ChildObjects.Add(cObj.Clone());
}
if (i < tbCell.ChildObjects.Count - 1)
{
newPara.AppendText("\n");
}
}
}
CopyTextAndStyle(cell, newPara);
}
//Copy text and style of a paragraph to a cell
private static void CopyTextAndStyle(CellRange cell, Paragraph paragraph)
{
RichText richText = cell.RichText;
richText.Text = paragraph.Text;
int startIndex = 0;
foreach (DocumentObject documentObject in paragraph.ChildObjects)
{
if (documentObject is TextRange)
{
TextRange textRange = documentObject as TextRange;
string fontName = textRange.CharacterFormat.FontName;
bool isBold = textRange.CharacterFormat.Bold;
Color textColor = textRange.CharacterFormat.TextColor;
float fontSize = textRange.CharacterFormat.FontSize;
string textRangeText = textRange.Text;
int strLength = textRangeText.Length;
ExcelFont font = cell.Worksheet.Workbook.CreateFont();
font.Color = textColor;
font.IsBold = isBold;
font.Size = fontSize;
font.FontName = fontName;
int endIndex = startIndex + strLength;
richText.SetFont(startIndex, endIndex, font);
startIndex += strLength;
}
if (documentObject is DocPicture)
{
DocPicture picture = documentObject as DocPicture;
cell.Worksheet.Pictures.Add(cell.Row, cell.Column, picture.Image);
cell.Worksheet.SetRowHeightInPixels(cell.Row, 1, picture.Image.Height);
}
}
switch (paragraph.Format.HorizontalAlignment)
{
case HorizontalAlignment.Left:
cell.Style.HorizontalAlignment = HorizontalAlignType.Left;
break;
case HorizontalAlignment.Center:
cell.Style.HorizontalAlignment = HorizontalAlignType.Center;
break;
case HorizontalAlignment.Right:
cell.Style.HorizontalAlignment = HorizontalAlignType.Right;
break;
}
}
}
}

Richiedi una licenza temporanea
Se desideri rimuovere il messaggio di valutazione dai documenti generati o eliminare le limitazioni delle funzioni, per favore richiedere una licenza di prova di 30 giorni per te.
C#/VB.NET : convertir Word en Excel
Table des matières
Installé via NuGet
PM> Install-Package Spire.Office
Liens connexes
Word et Excel sont deux types de fichiers complètement différents. Les documents Word sont utilisés pour rédiger des essais, des lettres ou créer des rapports, tandis que les documents Excel sont utilisés pour enregistrer des données sous forme de tableau, créer des graphiques ou effectuer des calculs mathématiques. Il n'est pas recommandé de convertir un document Word complexe en feuille de calcul Excel car Excel peut difficilement restituer le contenu selon sa mise en page d'origine dans Word.
Toutefois, si votre document Word est principalement composé de tableaux et que vous souhaitez analyser les données du tableau dans Excel, vous pouvez utiliser Spire.Office for .NET pour convertir Word en Excel alors que conservant une bonne lisibilité.
Installer Spire.Office for .NET
Pour commencer, vous devez ajouter les fichiers DLL inclus dans le package Spire.Office for .NET en tant que références dans votre projet .NET. Les fichiers DLL peuvent être téléchargés depuis ce lien ou installé via NuGet.
PM> Install-Package Spire.Office
Convertir Word en Excel en C# et VB.NET
Ce scénario utilise en fait deux bibliothèques dans le package Spire.Office. Ce sont Spire.Doc for .NET et Spire.XLS for .NET. Le premier est utilisé pour lire et extraire le contenu d'un document Word, et le second est utilisé pour créer un document Excel et écrire des données dans les cellules spécifiques. Pour rendre cet exemple de code facile à comprendre, nous avons créé les trois méthodes personnalisées suivantes qui exécutent des fonctions spécifiques.
- ExportTableInExcel() - Exporte les données d'un tableau Word vers des cellules Excel spécifiées.
- CopyContentInTable() - Copie le contenu d'une cellule de tableau dans Word vers une cellule Excel.
- CopyTextAndStyle() - Copie du texte avec mise en forme d'un paragraphe Word vers une cellule Excel.
Les étapes suivantes montrent comment exporter des données d'un document Word entier vers une feuille de calcul à l'aide de Spire.Office for .NET.
- Créez un objet Document pour charger un fichier Word.
- Créez un objet Worbbook et ajoutez-y une feuille de calcul nommée "WordToExcel".
- Parcourez toutes les sections du document Word, parcourez tous les objets de document sous une certaine section, puis déterminez si un objet de document est un paragraphe ou un tableau.
- Si l'objet document est un paragraphe, écrivez le paragraphe dans une cellule spécifiée dans Excel à l'aide de la méthode CoypTextAndStyle().
- Si l'objet document est un tableau, exportez les données du tableau de Word vers des cellules Excel à l'aide de la méthode ExportTableInExcel().
- Ajustez automatiquement la hauteur de ligne et la largeur de colonne dans Excel afin que les données d'une cellule ne dépassent pas la limite de la cellule.
- Enregistrez le classeur dans un fichier Excel à l'aide de la méthode Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Doc;
using Spire.Doc.Documents;
using Spire.Doc.Fields;
using Spire.Xls;
using System;
using System.Drawing;
namespace ConvertWordToExcel
{
class Program
{
static void Main(string[] args)
{
//Create a Document object
Document doc = new Document();
//Load a Word file
doc.LoadFromFile(@"C:\Users\Administrator\Desktop\Invoice.docx");
//Create a Workbook object
Workbook wb = new Workbook();
//Remove the default worksheets
wb.Worksheets.Clear();
//Create a worksheet named "WordToExcel"
Worksheet worksheet = wb.CreateEmptySheet("WordToExcel");
int row = 1;
int column = 1;
//Loop through the sections in the Word document
foreach (Section section in doc.Sections)
{
//Loop through the document object under a certain section
foreach (DocumentObject documentObject in section.Body.ChildObjects)
{
//Determine if the object is a paragraph
if (documentObject is Paragraph)
{
CellRange cell = worksheet.Range[row, column];
Paragraph paragraph = documentObject as Paragraph;
//Copy paragraph from Word to a specific cell
CopyTextAndStyle(cell, paragraph);
row++;
}
//Determine if the object is a table
if (documentObject is Table)
{
Table table = documentObject as Table;
//Export table data from Word to Excel
int currentRow = ExportTableInExcel(worksheet, row, table);
row = currentRow;
}
}
}
//Auto fit row height and column width
worksheet.AllocatedRange.AutoFitRows();
worksheet.AllocatedRange.AutoFitColumns();
//Wrap text in cells
worksheet.AllocatedRange.IsWrapText = true;
//Save the workbook to an Excel file
wb.SaveToFile("WordToExcel.xlsx", ExcelVersion.Version2013);
}
//Export data from Word table to Excel cells
private static int ExportTableInExcel(Worksheet worksheet, int row, Table table)
{
CellRange cell;
int column;
foreach (TableRow tbRow in table.Rows)
{
column = 1;
foreach (TableCell tbCell in tbRow.Cells)
{
cell = worksheet.Range[row, column];
cell.BorderAround(LineStyleType.Thin, Color.Black);
CopyContentInTable(tbCell, cell);
column++;
}
row++;
}
return row;
}
//Copy content from a Word table cell to an Excel cell
private static void CopyContentInTable(TableCell tbCell, CellRange cell)
{
Paragraph newPara = new Paragraph(tbCell.Document);
for (int i = 0; i < tbCell.ChildObjects.Count; i++)
{
DocumentObject documentObject = tbCell.ChildObjects[i];
if (documentObject is Paragraph)
{
Paragraph paragraph = documentObject as Paragraph;
foreach (DocumentObject cObj in paragraph.ChildObjects)
{
newPara.ChildObjects.Add(cObj.Clone());
}
if (i < tbCell.ChildObjects.Count - 1)
{
newPara.AppendText("\n");
}
}
}
CopyTextAndStyle(cell, newPara);
}
//Copy text and style of a paragraph to a cell
private static void CopyTextAndStyle(CellRange cell, Paragraph paragraph)
{
RichText richText = cell.RichText;
richText.Text = paragraph.Text;
int startIndex = 0;
foreach (DocumentObject documentObject in paragraph.ChildObjects)
{
if (documentObject is TextRange)
{
TextRange textRange = documentObject as TextRange;
string fontName = textRange.CharacterFormat.FontName;
bool isBold = textRange.CharacterFormat.Bold;
Color textColor = textRange.CharacterFormat.TextColor;
float fontSize = textRange.CharacterFormat.FontSize;
string textRangeText = textRange.Text;
int strLength = textRangeText.Length;
ExcelFont font = cell.Worksheet.Workbook.CreateFont();
font.Color = textColor;
font.IsBold = isBold;
font.Size = fontSize;
font.FontName = fontName;
int endIndex = startIndex + strLength;
richText.SetFont(startIndex, endIndex, font);
startIndex += strLength;
}
if (documentObject is DocPicture)
{
DocPicture picture = documentObject as DocPicture;
cell.Worksheet.Pictures.Add(cell.Row, cell.Column, picture.Image);
cell.Worksheet.SetRowHeightInPixels(cell.Row, 1, picture.Image.Height);
}
}
switch (paragraph.Format.HorizontalAlignment)
{
case HorizontalAlignment.Left:
cell.Style.HorizontalAlignment = HorizontalAlignType.Left;
break;
case HorizontalAlignment.Center:
cell.Style.HorizontalAlignment = HorizontalAlignType.Center;
break;
case HorizontalAlignment.Right:
cell.Style.HorizontalAlignment = HorizontalAlignType.Right;
break;
}
}
}
}

Demander une licence temporaire
Si vous souhaitez supprimer le message d'évaluation des documents générés ou vous débarrasser des limitations de la fonction, veuillez demander une licence d'essai de 30 jours pour toi.
C#/VB.NET: преобразование Word в HTML
Установлено через NuGet
PM> Install-Package Spire.Doc
Ссылки по теме
Если вы хотите разместить документ Word в Интернете, рекомендуется преобразовать документ в HTML, чтобы сделать его доступным через веб-страницу. Эта статья продемонстрирует как конвертировать Word в HTML программно в C# и VB.NET с использованием Spire.Doc for .NET.
Установите Spire.Doc for .NET
Для начала вам необходимо добавить файлы DLL, включенные в пакет Spire.Doc for .NET, в качестве ссылок в ваш проект .NET. Файлы DLL можно загрузить с эта ссылка или установлен через NuGet.
PM> Install-Package Spire.Doc
Преобразование Word в HTML
Следующие шаги показывают, как преобразовать Word в HTML с помощью Spire.Doc for .NET.
- Создайте экземпляр документа.
- Загрузите образец документа Word с помощью метода Document.LoadFromFile().
- Сохраните документ как файл HTML, используя метод Document.SaveToFile().
- C#
- VB.NET
using Spire.Doc;
namespace WordToHTML
{
class Program
{
static void Main(string[] args)
{
//Create a Document instance
Document mydoc = new Document();
//Load a Word document
mydoc.LoadFromFile("sample.docx");
//Save to HTML
mydoc.SaveToFile("WordToHTML.html", FileFormat.Html);
}
}
}

Подать заявку на временную лицензию
Если вы хотите удалить оценочное сообщение из сгенерированных документов или избавиться от функциональных ограничений, пожалуйста запросить 30-дневную пробную лицензию для себя.
C#/VB.NET: Converter Excel em PDF
Índice
Instalado via NuGet
PM> Install-Package Spire.XLS
Links Relacionados
Ao converter um arquivo do Excel para o formato PDF, qualquer pessoa pode abrir o arquivo mesmo quando não houver o Office instalado no sistema. Além disso, a conversão de documentos do Excel em PDF é útil, pois os arquivos PDF podem ser facilmente compartilhados e impressos. Neste artigo, você aprenderá como converter um documento inteiro do Excel ou uma planilha específica em PDF usando o Spire.XLS for .NET.
Instalar o Spire.XLS for .NET
Para começar, você precisa adicionar os arquivos DLL incluídos no pacote Spire.XLS for .NET como referências em seu projeto .NET. Os arquivos DLL podem ser baixados deste link ou instalados via NuGet.
PM> Install-Package Spire.XLS
Converter um documento inteiro do Excel em PDF
A seguir estão as etapas para converter um documento inteiro do Excel em PDF usando o Spire.XLS for .NET.
- Crie um objeto Pasta de trabalho.
- Carregue um documento Excel de amostra usando o método Workbook.LoadFromFile().
- Defina as opções de conversão de Excel para PDF por meio das propriedades na classe ConverterSetting.
- Converta todo o documento do Excel em PDF usando o método Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Converter uma planilha específica para PDF
A seguir estão as etapas para converter uma planilha específica em PDF usando o Spire.XLS for .NET.
- Crie um objeto Pasta de trabalho.
- Carregue um documento Excel de amostra usando o método Workbook.LoadFromFile().
- Defina as opções de conversão de Excel para PDF por meio das propriedades na classe ConverterSetting.
- Obtenha uma planilha específica por meio da propriedade Workbook.Worksheets[index].
- Converta a planilha em PDF usando o método Worksheet.SaveToPdf().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Solicitar uma licença temporária
Se você deseja remover a mensagem de avaliação dos documentos gerados ou se livrar das limitações de função, por favor solicite uma licença de teste de 30 dias para você mesmo.
C#/VB.NET: преобразование Excel в PDF
Оглавление
Установлено через NuGet
PM> Install-Package Spire.XLS
Ссылки по теме
Преобразовав файл Excel в формат PDF, любой может открыть файл, даже если в системе не установлен пакет Office. Кроме того, преобразование документов Excel в PDF полезно, поскольку PDF-файлами можно легко делиться и распечатывать. В этой статье вы узнаете, как преобразовать весь документ Excel или конкретный рабочий лист в PDF с помощью Spire.XLS for .NET.
Установите Spire.XLS for .NET
Для начала вам нужно добавить файлы DLL, включенные в пакет Spire.XLS for .NET, в качестве ссылок в ваш проект .NET. Файлы DLL можно загрузить с эта ссылка или установлен через NuGet.
PM> Install-Package Spire.XLS
Преобразование всего документа Excel в PDF
Ниже приведены шаги по преобразованию всего документа Excel в PDF с помощью Spire.XLS for .NET.
- СоздатьРабочая тетрадьобъект.
- Загрузите образец документа Excel с помощью метода Workbook.LoadFromFile().
- Установите параметры преобразования Excel в PDF с помощью свойств в классе ConverterSetting.
- Преобразуйте весь документ Excel в PDF, используя метод Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Преобразование определенного рабочего листа в PDF
Ниже приведены шаги по преобразованию определенного рабочего листа в PDF с помощью Spire.XLS for .NET.
- Создать Рабочая тетрадь объект.
- Загрузите образец документа Excel с помощью метода Workbook.LoadFromFile().
- Установите параметры преобразования Excel в PDF с помощью свойств в классе ConverterSetting.
- Получите конкретный рабочий лист с помощью свойства Workbook.Worksheets[index].
- Преобразуйте рабочий лист в PDF, используя метод Worksheet.SaveToPdf().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Подать заявку на временную лицензию
Если вы хотите удалить оценочное сообщение из сгенерированных документов или избавиться от функциональных ограничений, пожалуйста запросить 30-дневную пробную лицензию для себя.
C#/VB.NET: Excel in PDF konvertieren
Inhaltsverzeichnis
Über NuGet installiert
PM> Install-Package Spire.XLS
verwandte Links
Durch die Konvertierung einer Excel-Datei in das PDF-Format kann jeder die Datei öffnen, auch wenn kein Office auf dem System installiert ist. Auch das Konvertieren von Excel-Dokumenten in PDF ist nützlich, da PDF-Dateien problemlos geteilt und gedruckt werden können. In diesem Artikel erfahren Sie, wie das geht Konvertieren Sie ein ganzes Excel-Dokument oder ein bestimmtes Arbeitsblatt in PDF umwandeln mit Spire.XLS for .NET.
- Konvertieren Sie ein ganzes Excel-Dokument in PDF
- Konvertieren Sie ein bestimmtes Arbeitsblatt in PDF
Installieren Spire.XLS for .NET
Zunächst müssen Sie die im Spire.XLS for .NET-Paket enthaltenen DLL-Dateien als Referenzen in Ihrem .NET-Projekt hinzufügen. Die DLL-Dateien können entweder über diesen Link heruntergeladen oder über NuGet installiert werden.
PM> Install-Package Spire.XLS
Konvertieren Sie ein ganzes Excel-Dokument in PDF
Im Folgenden finden Sie die Schritte zum Konvertieren eines gesamten Excel-Dokuments in PDF mit Spire.XLS for .NET.
- Erstellen Sie ein Workbook-Objekt.
- Laden Sie ein Beispiel-Excel-Dokument mit der Methode Workbook.LoadFromFile().
- Legen Sie die Optionen für die Konvertierung von Excel in PDF über die Eigenschaften unter der Klasse „ConverterSetting“ fest.
- Konvertieren Sie das gesamte Excel-Dokument mit der Methode Workbook.SaveToFile() in PDF.
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Konvertieren Sie ein bestimmtes Arbeitsblatt in PDF
Im Folgenden finden Sie die Schritte zum Konvertieren eines bestimmten Arbeitsblatts in PDF mit Spire.XLS for .NET.
- Erstellen Sie ein Workbook-Objekt.
- Laden Sie ein Beispiel-Excel-Dokument mit der Methode Workbook.LoadFromFile().
- Legen Sie die Optionen für die Konvertierung von Excel in PDF über die Eigenschaften unter der Klasse „ConverterSetting“ fest.
- Rufen Sie ein bestimmtes Arbeitsblatt über die Eigenschaft Workbook.Worksheets[index] ab.
- Konvertieren Sie das Arbeitsblatt mit der Methode Worksheet.SaveToPdf() in PDF.
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Beantragen Sie eine temporäre Lizenz
Wenn Sie die Bewertungsmeldung aus den generierten Dokumenten entfernen oder die Funktionseinschränkungen beseitigen möchten, wenden Sie sich bitte an uns Fordern Sie eine 30-Tage-Testlizenz an für sich selbst.
C#/VB.NET: Convertir Excel a PDF
Tabla de contenido
Instalado a través de NuGet
PM> Install-Package Spire.XLS
enlaces relacionados
Al convertir un archivo de Excel a formato PDF, cualquiera puede abrir el archivo incluso cuando no hay Office instalado en el sistema. Además, la conversión de documentos de Excel a PDF es útil, ya que los archivos PDF se pueden compartir e imprimir fácilmente. En este artículo, aprenderá cómo convertir todo un documento de Excel o una hoja de trabajo específica en PDF utilizando Spire.XLS for .NET.
Instalar Spire.XLS for .NET
Para empezar, debe agregar los archivos DLL incluidos en el paquete Spire.XLS for .NET como referencias en su proyecto .NET. Los archivos DLL se pueden descargar desde este enlace o instalar a través deNuGet.
PM> Install-Package Spire.XLS
Convertir un documento completo de Excel a PDF
Los siguientes son los pasos para convertir un documento completo de Excel a PDF utilizando Spire.XLS for .NET.
- Cree un objeto de libro de trabajo.
- Cargue un documento de Excel de muestra usando el método Workbook.LoadFromFile().
- Establezca las opciones de conversión de Excel a PDF a través de las propiedades en la clase ConverterSetting.
- Convierta todo el documento de Excel a PDF usando el método Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Convertir una hoja de trabajo específica a PDF
Los siguientes son los pasos para convertir una hoja de trabajo específica a PDF utilizando Spire.XLS for .NET.
- Cree un objeto de libro de trabajo.
- Cargue un documento de Excel de muestra usando el método Workbook.LoadFromFile().
- Establezca las opciones de conversión de Excel a PDF a través de las propiedades en la clase ConverterSetting.
- Obtenga una hoja de trabajo específica a través de la propiedad Workbook.Worksheets[index].
- Convierta la hoja de trabajo a PDF usando el método Worksheet.SaveToPdf().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Solicitar una Licencia Temporal
Si desea eliminar el mensaje de evaluación de los documentos generados o deshacerse de las limitaciones de la función, por favor solicitar una licencia de prueba de 30 días para ti.
C#/VB.NET: Excel을 PDF로 변환
NuGet을 통해 설치됨
PM> Install-Package Spire.XLS
관련된 링크들
Excel 파일을 PDF 형식으로 변환하면 시스템에 Office가 설치되어 있지 않아도 누구나 파일을 열 수 있습니다. 또한 Excel 문서를 PDF로 변환하면 PDF 파일을 쉽게 공유하고 인쇄할 수 있으므로 유용합니다. 이 기사에서는 다음을 수행하는 방법을 배웁니다 전체 Excel 문서를 변환 또는 특정 워크시트 를 사용하여 PDF로 Spire.XLS for .NET.
Spire.XLS for .NET 설치
먼저 Spire.XLS for .NET 패키지에 포함된 DLL 파일을 .NET 프로젝트의 참조로 추가해야 합니다. DLL 파일은 다음에서 다운로드할 수 있습니다 이 링크 또는 NuGet을 통해 설치됩니다. NuGet.
PM> Install-Package Spire.XLS
전체 Excel 문서를 PDF로 변환
다음은 Spire.XLS for .NET을 사용하여 전체 Excel 문서를 PDF로 변환하는 단계입니다.
- 만들기 학습장 물체.
- Workbook.LoadFromFile() 메서드를 사용하여 샘플 Excel 문서를 로드합니다.
- ConverterSetting 클래스 아래의 속성을 통해 Excel에서 PDF로 변환 옵션을 설정합니다.
- Workbook.SaveToFile() 메서드를 사용하여 전체 Excel 문서를 PDF로 변환합니다.
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

특정 워크시트를 PDF로 변환
다음은 Spire.XLS for .NET을 사용하여 특정 워크시트를 PDF로 변환하는 단계입니다.
- 만들기 학습장 물체.
- Workbook.LoadFromFile() 메서드를 사용하여 샘플 Excel 문서를 로드합니다.
- ConverterSetting 클래스 아래의 속성을 통해 Excel에서 PDF로 변환 옵션을 설정합니다.
- Workbook.Worksheets[index] 속성을 통해 특정 워크시트를 가져옵니다.
- Worksheet.SaveToPdf() 메서드를 사용하여 워크시트를 PDF로 변환합니다.
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

임시 면허 신청
생성된 문서에서 평가 메시지를 제거하거나 기능 제한을 제거하려면 다음을 수행하십시오 30일 평가판 라이선스 요청 자신을 위해.
C#/VB.NET: Converti Excel in PDF
Sommario
Installato tramite NuGet
PM> Install-Package Spire.XLS
Link correlati
Convertendo un file Excel in formato PDF, chiunque può aprire il file anche quando non è installato Office nel sistema. Inoltre, la conversione di documenti Excel in PDF è utile in quanto i file PDF possono essere facilmente condivisi e stampati. In questo articolo imparerai come convertire un intero documento Excel O un foglio di lavoro specifico in PDF utilizzando Spire.XLS for .NET.
Installa Spire.XLS for .NET
Per cominciare, è necessario aggiungere i file DLL inclusi nel pacchetto Spire.XLS for .NET come riferimenti nel progetto .NET. I file DLL possono essere scaricati da questo link o installato tramite NuGet.
PM> Install-Package Spire.XLS
Converti un intero documento Excel in PDF
Di seguito sono riportati i passaggi per convertire un intero documento Excel in PDF utilizzando Spire.XLS for .NET.
- Crea un oggetto cartella di lavoro.
- Carica un documento Excel di esempio utilizzando il metodo Workbook.LoadFromFile().
- Impostare le opzioni di conversione da Excel a PDF tramite le proprietà della classe ConverterSetting.
- Converti l'intero documento Excel in PDF utilizzando il metodo Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Converti un foglio di lavoro specifico in PDF
Di seguito sono riportati i passaggi per convertire un foglio di lavoro specifico in PDF utilizzando Spire.XLS for .NET.
- Crea un oggetto cartella di lavoro.
- Carica un documento Excel di esempio utilizzando il metodo Workbook.LoadFromFile().
- Impostare le opzioni di conversione da Excel a PDF tramite le proprietà della classe ConverterSetting.
- Ottieni un foglio di lavoro specifico tramite la proprietà Workbook.Worksheets[index].
- Converti il foglio di lavoro in PDF usando il metodo Worksheet.SaveToPdf().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Richiedi una licenza temporanea
Se desideri rimuovere il messaggio di valutazione dai documenti generati o eliminare le limitazioni delle funzioni, per favore richiedere una licenza di prova di 30 giorni per te.
C#/VB.NET : convertir Excel en PDF
Table des matières
Installé via NuGet
PM> Install-Package Spire.XLS
Liens connexes
En convertissant un fichier Excel au format PDF, n'importe qui peut ouvrir le fichier même lorsqu'aucun Office n'est installé dans le système. De plus, la conversion de documents Excel en PDF est utile car les fichiers PDF peuvent être facilement partagés et imprimés. Dans cet article, vous apprendrez à convertir un document Excel entier ou une feuille de travail spécifique en PDF en utilisant Spire.XLS for .NET.
Installer Spire.XLS for .NET
Pour commencer, vous devez ajouter les fichiers DLL inclus dans le package Spire.XLS for .NET en tant que références dans votre projet .NET. Les fichiers DLL peuvent être téléchargés depuis ce lien ou installé via NuGet.
PM> Install-Package Spire.XLS
Convertir un document Excel entier en PDF
Voici les étapes pour convertir un document Excel entier en PDF à l'aide de Spire.XLS for .NET.
- Créez un objet Workbook.
- Chargez un exemple de document Excel à l'aide de la méthode Workbook.LoadFromFile().
- Définissez les options de conversion Excel en PDF via les propriétés sous la classe ConverterSetting.
- Convertissez l'intégralité du document Excel en PDF à l'aide de la méthode Workbook.SaveToFile().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertExcelToPDF
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Save to PDF
workbook.SaveToFile("ExcelToPdf.pdf", FileFormat.PDF);
}
}
}

Convertir une feuille de calcul spécifique en PDF
Voici les étapes pour convertir une feuille de calcul spécifique en PDF à l'aide de Spire.XLS for .NET.
- Créez un objet Workbook.
- Chargez un exemple de document Excel à l'aide de la méthode Workbook.LoadFromFile().
- Définissez les options de conversion Excel en PDF via les propriétés sous la classe ConverterSetting.
- Obtenez une feuille de calcul spécifique via la propriété Workbook.Worksheets[index].
- Convertissez la feuille de calcul en PDF à l'aide de la méthode Worksheet.SaveToPdf().
- C#
- VB.NET
using Spire.Xls;
namespace ConvertWorksheetToPdf
{
class Program
{
static void Main(string[] args)
{
//Create a Workbook instance
Workbook workbook = new Workbook();
//Load a sample Excel file
workbook.LoadFromFile("C:\\Users\\Administrator\\Desktop\\Sample.xlsx");
//Set worksheets to fit to page when converting
workbook.ConverterSetting.SheetFitToPage = true;
//Get the first worksheet
Worksheet worksheet = workbook.Worksheets[0];
//Save to PDF
worksheet.SaveToPdf("WorksheetToPdf.pdf");
}
}
}

Demander une licence temporaire
Si vous souhaitez supprimer le message d'évaluation des documents générés ou vous débarrasser des limitations de la fonction, veuillez demander une licence d'essai de 30 jours pour toi.