public void FindSlides()
{
const string file = "../../files/GetNotes.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(4, nbSlides);
{
IEnumerable<PptxSlide> slides = pptx.FindSlides("{{comment1}}");
Assert.AreEqual(1, slides.Count());
}
{
IEnumerable<PptxSlide> slides = pptx.FindSlides("{{comment2}}");
Assert.AreEqual(1, slides.Count());
}
{
IEnumerable<PptxSlide> slides = pptx.FindSlides("{{comment3}}");
Assert.AreEqual(1, slides.Count());
}
pptx.Close();
}
// GET: Pptx
public ActionResult Index()
{
var mng = new Pptx();
var sm = new SettingsManager();
mng.SetFolder(sm.GetSetting("folder_presentation", ""));
ViewBag.CountSlide = mng.CountSlide();
return(View());
}
public JsonResult SetParameters(string[] arrayParameters, int numberSlide)
{
var mng = new Pptx();
var sm = new SettingsManager();
mng.SetFolder(sm.GetSetting("folder_presentation", ""));
mng.SetPPTShapeText(arrayParameters, numberSlide);
return(new JsonResult()
{
Data = "jbsdlj",
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult DelitSlide(int numSlide, int count)
{
var mng = new Pptx();
var sm = new SettingsManager();
mng.SetFolder(sm.GetSetting("folder_presentation", ""));
bool newSlide = mng.DeleteSlide(numSlide, count);
return(new JsonResult
{
Data = newSlide,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public JsonResult AddSlide(int Count)
{
var mng = new Pptx();
var sm = new SettingsManager();
mng.SetFolder(sm.GetSetting("folder_presentation", ""));
bool newSlide = mng.CloneSlidePart(Count);
return(new JsonResult
{
Data = newSlide,
JsonRequestBehavior = JsonRequestBehavior.AllowGet
});
}
public void EmptyPowerPoint()
{
const string file = "../../files/EmptyPowerPoint.pptx";
const string thumbnail_empty_png = "../../files/thumbnail_empty.png";
const string thumbnail_empty_output_png = "../../files/thumbnail_empty_output.png";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(0, nbSlides);
byte[] thumbnail_empty_output = pptx.GetThumbnail();
File.WriteAllBytes(thumbnail_empty_output_png, thumbnail_empty_output);
byte[] thumbnail_empty = File.ReadAllBytes(thumbnail_empty_png);
CollectionAssert.AreEqual(thumbnail_empty, thumbnail_empty_output);
pptx.Close();
}
public void FailToReplaceTable()
{
const string srcFileName = "../../files/ReplaceTables.pptx";
const string dstFileName = "../../files/ReplaceTables_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
PptxSlide slide0 = pptx.GetSlide(0);
PptxSlide slide1 = pptx.GetSlide(1);
// Make it fail
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>();
var table = slide0.FindTables("{{table0}}").First();
Pptx.ReplaceTable_One(slide1, table, rows);
pptx.Close();
}
private void AssertPptxEquals(string file, int nbSlides, string expected)
{
Pptx pptx = new Pptx(file, FileAccess.Read);
Assert.AreEqual(nbSlides, pptx.SlidesCount());
StringBuilder result = new StringBuilder();
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
IEnumerable<string> texts = slide.GetTexts();
result.Append(string.Join(" ", texts));
result.Append(" ");
}
pptx.Close();
Assert.AreEqual(expected, result.ToString());
}
public void SetTableCellBackgroundPicture()
{
const string srcFileName = "../../files/SetTableCellBackgroundPicture.pptx";
const string dstFileName = "../../files/SetTableCellBackgroundPicture_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
const string icon_png = "../../files/icon.png";
const string icon_png_contentType = "image/png";
byte[] icon = File.ReadAllBytes(icon_png);
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>
{
new[]
{
new PptxTable.Cell(
"{{cell0.0}}",
"Hello, world! 0.0",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType,
Top = 14000,
Right = 90000,
Bottom = 12000,
Left = 0
}),
new PptxTable.Cell(
"{{cell3.0}}",
"Hello, world! 3.0",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType,
Top = 14000,
Right = 90000,
Bottom = 12000,
Left = 0
})
},
new[]
{
new PptxTable.Cell(
"{{cell0.1}}",
"Hello, world! 0.1",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType,
Top = 14000,
Right = 90000,
Bottom = 0,
Left = 0
})
},
new[]
{
new PptxTable.Cell(
"{{cell0.2}}",
"Hello, world! 0.2",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType,
Top = 14000,
Right = 0,
Bottom = 0,
Left = 0
})
},
new[]
{
new PptxTable.Cell(
"{{cell0.3}}",
"Hello, world! 0.3",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType,
Top = 0,
Right = 0,
Bottom = 0,
Left = 0
})
},
new[]
{
new PptxTable.Cell(
"{{cell0.4}}",
"Hello, world! 0.4",
new PptxTable.Cell.BackgroundPicture()
{
Content = icon,
ContentType = icon_png_contentType
})
},
new[]
{
new PptxTable.Cell("{{cell0.5}}", "Hello, world! 0.5"),
new PptxTable.Cell("{{cell3.5}}", "Hello, world! 3.5")
}
};
PptxSlide slideTemplate = pptx.GetSlide(0);
var table = slideTemplate.FindTables("{{table1}}").First();
var slidesCreated = Pptx.ReplaceTable_One(slideTemplate, table, rows);
Assert.AreEqual(1, slidesCreated.Count());
// Force a slide duplication
// This is to test that PptxSlide.Clone() works with background images
var slide = slidesCreated.First();
var slideClone = slide.Clone();
PptxSlide.InsertAfter(slideClone, slide);
slideTemplate.Remove();
pptx.Close();
this.AssertPptxEquals(dstFileName, 2, "Col0 Col1 Col2 Col3 Col4 Hello, world! 0.0 Hello {{cell2.0}} Hello, world! 3.0 {{cell4.0}} Hello, world! 0.1 Hello {{cell2.1}} {{cell3.1}} {{cell4.1}} Hello, world! 0.2 Hello {{cell2.2}} {{cell3.2}} {{cell4.2}} Hello, world! 0.3 Hello {{cell2.3}} {{cell3.3}} {{cell4.3}} Hello, world! 0.4 Hello {{cell2.4}} {{cell3.4}} {{cell4.4}} Hello, world! 0.5 Hello {{cell2.5}} Hello, world! 3.5 {{cell4.5}} Col0 Col1 Col2 Col3 Col4 Hello, world! 0.0 Hello {{cell2.0}} Hello, world! 3.0 {{cell4.0}} Hello, world! 0.1 Hello {{cell2.1}} {{cell3.1}} {{cell4.1}} Hello, world! 0.2 Hello {{cell2.2}} {{cell3.2}} {{cell4.2}} Hello, world! 0.3 Hello {{cell2.3}} {{cell3.3}} {{cell4.3}} Hello, world! 0.4 Hello {{cell2.4}} {{cell3.4}} {{cell4.4}} Hello, world! 0.5 Hello {{cell2.5}} Hello, world! 3.5 {{cell4.5}} ");
// Sorry, you will have to manually check the background pictures
}
public void TableColumnTitles()
{
const string file = "../../files/TableColumnTitles.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(1, nbSlides);
Assert.AreEqual(string.Empty, pptx.GetSlide(0).GetTitle());
var slidesTables = new Dictionary<int, PptxTable[]>();
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
IEnumerable<PptxTable> tables = slide.GetTables();
slidesTables.Add(i, tables.ToArray());
}
string[] expected = { "1 Multiple lines", "2", "3", "4", "5" };
CollectionAssert.AreEqual(expected, slidesTables[0][0].ColumnTitles().ToArray());
pptx.Close();
}
public void GetSlides()
{
const string file = "../../files/GetTexts.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(3, nbSlides);
IEnumerable<PptxSlide> slides = pptx.GetSlides();
Assert.AreEqual(3, slides.Count());
pptx.Close();
}
public void ReplaceTags()
{
const string srcFileName = "../../files/ReplaceTags.pptx";
const string dstFileName = "../../files/ReplaceTags_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(3, nbSlides);
// First slide
{
PptxSlide slide = pptx.GetSlide(0);
slide.ReplaceTag("{{hello}}", "HELLO HOW ARE YOU?", PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{bonjour}}", "BONJOUR TOUT LE MONDE", PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{hola}}", "HOLA MAMA QUE TAL?", PptxSlide.ReplacementType.Global);
}
// Second slide
{
PptxSlide slide = pptx.GetSlide(1);
slide.ReplaceTag("{{hello}}", "H", PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{bonjour}}", "B", PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{hola}}", "H", PptxSlide.ReplacementType.Global);
}
// Third slide
{
PptxSlide slide = pptx.GetSlide(2);
slide.ReplaceTag("{{hello}}", string.Empty, PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{bonjour}}", string.Empty, PptxSlide.ReplacementType.Global);
slide.ReplaceTag("{{hola}}", null, PptxSlide.ReplacementType.Global);
slide.ReplaceTag(null, string.Empty, PptxSlide.ReplacementType.Global);
slide.ReplaceTag(null, null, PptxSlide.ReplacementType.Global);
}
pptx.Close();
this.AssertPptxEquals(dstFileName, 3, "words HELLO HOW ARE YOU?|HELLO HOW ARE YOU?|HOLA MAMA QUE TAL?, world! A tag {{hoHOLA MAMA QUE TAL?la}} inside a sentence BONJOUR TOUT LE MONDE A tag BONJOUR TOUT LE MONDEHOLA MAMA QUE TAL?BONJOUR TOUT LE MONDE inside a sentence HELLO HOW ARE YOU?, world! words H|H|H, world! A tag {{hoHla}} inside a sentence B A tag BHB inside a sentence H, world! words ||, world! A tag inside a sentence A tag inside a sentence , world! ");
}
public void GetThumbnail()
{
string file = "../../files/GetTexts.pptx";
const string thumbnail_default_png = "../../files/thumbnail_default.png";
const string thumbnail_default_output_png = "../../files/thumbnail_default_output.png";
const string thumbnail_128x96_png = "../../files/thumbnail_128x96.png";
const string thumbnail_128x96_output_png = "../../files/thumbnail_128x96_output.png";
const string thumbnail_512x384_png = "../../files/thumbnail_512x384.png";
const string thumbnail_512x384_output_png = "../../files/thumbnail_512x384_output.png";
Pptx pptx = new Pptx(file, FileAccess.Read);
byte[] thumbnail_default_output = pptx.GetThumbnail(); // Default size
File.WriteAllBytes(thumbnail_default_output_png, thumbnail_default_output);
byte[] thumbnail_128x96_output = pptx.GetThumbnail(new Size(128, 96));
File.WriteAllBytes(thumbnail_128x96_output_png, thumbnail_128x96_output);
byte[] thumbnail_512x384_output = pptx.GetThumbnail(new Size(512, 384));
File.WriteAllBytes(thumbnail_512x384_output_png, thumbnail_512x384_output);
// Check the generated thumbnail are ok
byte[] thumbnail_default = File.ReadAllBytes(thumbnail_default_png);
CollectionAssert.AreEqual(thumbnail_default, thumbnail_default_output);
byte[] thumbnail_128x96 = File.ReadAllBytes(thumbnail_128x96_png);
CollectionAssert.AreEqual(thumbnail_128x96, thumbnail_128x96_output);
byte[] thumbnail_512x384 = File.ReadAllBytes(thumbnail_512x384_png); // Will look blurry
CollectionAssert.AreEqual(thumbnail_512x384, thumbnail_512x384_output);
pptx.Close();
// Test a 16/10 portrait PowerPoint file
file = "../../files/portrait_16_10.pptx";
const string thumbnail_portrait_16_10_png = "../../files/thumbnail_portrait_16_10.png";
const string thumbnail_portrait_16_10_output_png = "../../files/thumbnail_portrait_16_10_output.png";
pptx = new Pptx(file, FileAccess.Read);
byte[] thumbnail_portrait_16_10_output = pptx.GetThumbnail(); // Default size
File.WriteAllBytes(thumbnail_portrait_16_10_output_png, thumbnail_portrait_16_10_output);
byte[] thumbnail_portrait_16_10 = File.ReadAllBytes(thumbnail_portrait_16_10_png);
CollectionAssert.AreEqual(thumbnail_portrait_16_10, thumbnail_portrait_16_10_output);
pptx.Close();
}
public void ReplaceTablesAndPictures()
{
const string srcFileName = "../../files/ReplaceTablesAndPictures.pptx";
const string dstFileName = "../../files/ReplaceTablesAndPictures_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>
{
new[] { new PptxTable.Cell("{{cell}}", "1") },
new[] { new PptxTable.Cell("{{cell}}", "2") },
new[] { new PptxTable.Cell("{{cell}}", "3") },
new[] { new PptxTable.Cell("{{cell}}", "4") },
new[] { new PptxTable.Cell("{{cell}}", "5") },
new[] { new PptxTable.Cell("{{cell}}", "6") }
};
PptxSlide slideTemplate = pptx.GetSlide(0);
slideTemplate.ReplaceTag("{{cell}}", "Bonjour", PptxSlide.ReplacementType.NoTable);
const string picture1_replace_png = "../../files/picture1_replace.png";
const string picture1_replace_png_contentType = "image/png";
slideTemplate.ReplacePicture("{{picture1}}", picture1_replace_png, picture1_replace_png_contentType);
List<PptxSlide> existingSlides = new List<PptxSlide>();
{
var table = slideTemplate.FindTables("{{table1}}").First();
var slidesCreated = Pptx.ReplaceTable_Multiple(slideTemplate, table, rows, existingSlides);
existingSlides.AddRange(slidesCreated);
}
{
var table = slideTemplate.FindTables("{{table2}}").First();
var slidesCreated = Pptx.ReplaceTable_Multiple(slideTemplate, table, rows, existingSlides);
existingSlides.AddRange(slidesCreated);
}
slideTemplate.Remove();
pptx.Close();
this.AssertPptxEquals(dstFileName, 2, "Table1 1 2 3 4 Table2 1 2 3 4 Bonjour Table1 5 6 Table2 5 6 Bonjour ");
}
public void ReplacePictures()
{
const string srcFileName = "../../files/ReplacePictures.pptx";
const string dstFileName = "../../files/ReplacePictures_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(2, nbSlides);
Assert.AreEqual(string.Empty, pptx.GetSlide(0).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(1).GetTitle());
{
PptxSlide slide = pptx.GetSlide(0);
slide.ReplaceTag("{{hello}}", "HELLO!", PptxSlide.ReplacementType.Global);
}
const string picture1_replace_png = "../../files/picture1_replace.png";
const string picture1_replace_png_contentType = "image/png";
const string picture1_replace_bmp = "../../files/picture1_replace.bmp";
const string picture1_replace_bmp_contentType = "image/bmp";
const string picture1_replace_jpeg = "../../files/picture1_replace.jpeg";
const string picture1_replace_jpeg_contentType = "image/jpeg";
byte[] picture1_replace_empty = new byte[] { };
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
slide.ReplacePicture("{{picture1png}}", picture1_replace_png, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1bmp}}", picture1_replace_bmp, picture1_replace_bmp_contentType);
slide.ReplacePicture("{{picture1jpeg}}", picture1_replace_jpeg, picture1_replace_jpeg_contentType);
slide.ReplacePicture(null, picture1_replace_png, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1null}}", picture1_replace_empty, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1null}}", picture1_replace_png, null);
slide.ReplacePicture("{{picture1null}}", picture1_replace_empty, null);
}
pptx.Close();
// Sorry, you will have to manually check that the pictures have been replaced
}
public void ReplaceTableMultipleTimes()
{
const string srcFileName = "../../files/ReplaceTableMultipleTimes.pptx";
const string dstFileName = "../../files/ReplaceTableMultipleTimes_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
// Après la bataille (Victor Hugo)
// http://fr.wikisource.org/wiki/Apr%C3%A8s_la_bataille_(Hugo)
const string apresLaBataille =
@"Mon père, ce héros au sourire si doux,
Suivi d’un seul housard qu’il aimait entre tous
Pour sa grande bravoure et pour sa haute taille,
Parcourait à cheval, le soir d’une bataille,
Le champ couvert de morts sur qui tombait la nuit.
Il lui sembla dans l’ombre entendre un faible bruit.
C’était un Espagnol de l’armée en déroute
Qui se traînait sanglant sur le bord de la route,
Râlant, brisé, livide, et mort plus qu’à moitié,
Et qui disait : « À boire ! à boire par pitié ! »
Mon père, ému, tendit à son housard fidèle
Une gourde de rhum qui pendait à sa selle,
Et dit : « Tiens, donne à boire à ce pauvre blessé. »
Tout à coup, au moment où le housard baissé
Se penchait vers lui, l’homme, une espèce de Maure,
Saisit un pistolet qu’il étreignait encore,
Et vise au front mon père en criant : « Caramba ! »
Le coup passa si près, que le chapeau tomba
Et que le cheval fit un écart en arrière.
« Donne-lui tout de même à boire », dit mon père.";
// Le Dormeur du val (Arthur Rimbaud)
// http://fr.wikisource.org/wiki/Le_Dormeur_du_val
const string dormeurDuVal =
@"C’est un trou de verdure où chante une rivière
Accrochant follement aux herbes des haillons
D’argent ; où le soleil, de la montagne fière,
Luit : c’est un petit val qui mousse de rayons.
Un soldat jeune, bouche ouverte, tête nue,
Et la nuque baignant dans le frais cresson bleu,
Dort ; il est étendu dans l’herbe, sous la nue,
Pâle dans son lit vert où la lumière pleut.
Les pieds dans les glaïeuls, il dort. Souriant comme
Sourirait un enfant malade, il fait un somme :
Nature, berce-le chaudement : il a froid.
Les parfums ne font pas frissonner sa narine ;
Il dort dans le soleil, la main sur sa poitrine
Tranquille. Il a deux trous rouges au côté droit.";
List<List<string[]>> poems = new List<List<string[]>>();
{
string[] apresLaBatailleLines = apresLaBataille.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
List<string[]> lines = new List<string[]>();
foreach (string line in apresLaBatailleLines)
{
lines.Add(line.Split(new string[] { " " }, StringSplitOptions.None));
}
poems.Add(lines);
}
{
string[] dormeurDuValLines = dormeurDuVal.Split(new string[] { Environment.NewLine }, StringSplitOptions.None);
List<string[]> lines = new List<string[]>();
foreach (string line in dormeurDuValLines)
{
lines.Add(line.Split(new string[] { " " }, StringSplitOptions.None));
}
poems.Add(lines);
}
{
PptxSlide slideTemplate = pptx.GetSlide(0);
List<PptxSlide> existingSlides = new List<PptxSlide>();
PptxTable tableTemplate = slideTemplate.FindTables("{{table1}}").First();
int rowsCountTemplate = tableTemplate.ColumnTitles().Count();
PptxSlide prevSlide = slideTemplate;
for (int i = 0; i < poems.Count; i++)
{
PptxSlide slideTemplate2 = slideTemplate.Clone();
PptxSlide.InsertAfter(slideTemplate2, prevSlide);
slideTemplate2.ReplaceTag("{{title}}", i.ToString(), PptxSlide.ReplacementType.NoTable);
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>();
List<string[]> poem = poems[i];
foreach (string[] line in poem)
{
List<PptxTable.Cell> row = new List<PptxTable.Cell>();
for (int j = 0; j < rowsCountTemplate; j++)
{
PptxTable.Cell cell = new PptxTable.Cell("{{cell" + j + "}}", j < line.Length ? line[j] : string.Empty);
row.Add(cell);
}
rows.Add(row.ToArray());
}
var table = slideTemplate2.FindTables("{{table1}}").First();
var slidesCreated = Pptx.ReplaceTable_One(slideTemplate2, table, rows);
existingSlides.AddRange(slidesCreated);
PptxSlide lastInsertedSlide = existingSlides.Last();
prevSlide = lastInsertedSlide;
slideTemplate2.Remove();
}
slideTemplate.Remove();
}
pptx.Close();
this.AssertPptxEquals(dstFileName, 6, "Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 Mon père, ce héros au sourire si doux, Suivi d’un seul housard qu’il aimait entre tous Pour sa grande bravoure et pour sa haute taille, Parcourait à cheval, le soir d’une bataille, Le champ couvert de morts sur qui tombait la nuit. Il lui sembla dans l’ombre entendre un faible bruit. C’était un Espagnol de l’armée en déroute 0 Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 Qui se traînait sanglant sur le bord de la route, Râlant, brisé, livide, et mort plus qu’à moitié, Et qui disait : « À boire ! à boire par pitié ! » Mon père, ému, tendit à son housard fidèle Une gourde de rhum qui pendait à sa selle, Et dit : « Tiens, donne à boire à ce pauvre blessé. » Tout à coup, au moment où le housard baissé 0 Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 Se penchait vers lui, l’homme, une espèce de Maure, Saisit un pistolet qu’il étreignait encore, Et vise au front mon père en criant : « Caramba ! » Le coup passa si près, que le chapeau tomba Et que le cheval fit un écart en arrière. « Donne-lui tout de même à boire », dit mon père. 0 Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 C’est un trou de verdure où chante une rivière Accrochant follement aux herbes des haillons D’argent ; où le soleil, de la montagne fière, Luit : c’est un petit val qui mousse de rayons. Un soldat jeune, bouche ouverte, tête nue, Et la nuque baignant dans le frais cresson bleu, 1 Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 Dort ; il est étendu dans l’herbe, sous la nue, Pâle dans son lit vert où la lumière pleut. Les pieds dans les glaïeuls, il dort. Souriant comme Sourirait un enfant malade, il fait un somme : Nature, berce-le chaudement : il a froid. 1 Col0 Col1 Col2 Col3 Col4 Col5 Col6 Col7 Col8 Col9 Col10 Col11 Col12 Col13 Les parfums ne font pas frissonner sa narine ; Il dort dans le soleil, la main sur sa poitrine Tranquille. Il a deux trous rouges au côté droit. 1 ");
}
public void GetTables()
{
const string file = "../../files/ReplaceTables.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(3, nbSlides);
Assert.AreEqual(string.Empty, pptx.GetSlide(0).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(1).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(2).GetTitle());
var slidesTables = new Dictionary<int, PptxTable[]>();
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
IEnumerable<PptxTable> tables = slide.GetTables();
slidesTables.Add(i, tables.ToArray());
}
string[] expected = { "Table1", "Col2", "Col3", "Col4", "Col5", "Col6" };
CollectionAssert.AreEqual(expected, slidesTables[1][0].ColumnTitles().ToArray());
expected = new string[] { "Table2", "Col2", "Col3", "Col4", "Col5", "Col6" };
CollectionAssert.AreEqual(expected, slidesTables[1][1].ColumnTitles().ToArray());
expected = new string[] { "Table3", "Col2", "Col3", "Col4", "Col5", "Col6" };
CollectionAssert.AreEqual(expected, slidesTables[1][2].ColumnTitles().ToArray());
pptx.Close();
}
public void ReplaceLotsOfPicturesAndSlides()
{
const string srcFileName = "../../files/ReplaceLotsOfPicturesAndSlides.pptx";
const string dstFileName = "../../files/ReplaceLotsOfPicturesAndSlides_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
const string picture1_replace_png = "../../files/picture1_replace.png";
const string picture1_replace_png_contentType = "image/png";
const string picture1_replace_bmp = "../../files/picture1_replace.bmp";
const string picture1_replace_bmp_contentType = "image/bmp";
const string picture1_replace_jpeg = "../../files/picture1_replace.jpeg";
const string picture1_replace_jpeg_contentType = "image/jpeg";
byte[] picture1_replace_empty = new byte[] { };
PptxSlide slideTemplate = pptx.FindSlides("{{LotsOfPictures}}").FirstOrDefault();
int nbSlidesToGenerate = 100;
for (int i = 0; i < nbSlidesToGenerate; i++)
{
PptxSlide slide = slideTemplate.Clone();
PptxSlide.InsertAfter(slide, slideTemplate);
slide.ReplacePicture("{{picture1png}}", picture1_replace_png, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1bmp}}", picture1_replace_bmp, picture1_replace_bmp_contentType);
slide.ReplacePicture("{{picture1jpeg}}", picture1_replace_jpeg, picture1_replace_jpeg_contentType);
slide.ReplacePicture(null, picture1_replace_png, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1null}}", picture1_replace_empty, picture1_replace_png_contentType);
slide.ReplacePicture("{{picture1null}}", picture1_replace_png, null);
slide.ReplacePicture("{{picture1null}}", picture1_replace_empty, null);
}
slideTemplate.Remove();
pptx.Close();
// Sorry, you will have to manually check that the pictures have been replaced
}
public void RemoveSlides()
{
const string srcFileName = "../../files/RemoveSlides.pptx";
const string dstFileName = "../../files/RemoveSlides_output.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
Assert.AreEqual(5, pptx.SlidesCount());
pptx.GetSlide(1).Remove();
Assert.AreEqual(4, pptx.SlidesCount());
pptx.Close();
pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
Assert.AreEqual(4, pptx.SlidesCount());
pptx.GetSlide(0).Remove();
pptx.GetSlide(2).Remove(); // 2 = 3 - the first slide removed
Assert.AreEqual(2, pptx.SlidesCount());
pptx.Close();
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(5, nbSlides);
for (int i = nbSlides - 1; i >= 0; i--)
{
if (i == 0 || i == 2)
{
pptx.GetSlide(i).Remove();
}
}
Assert.AreEqual(3, pptx.SlidesCount());
pptx.Close();
}
public void RemoveInvalidXMLChars()
{
const string srcFileName = "../../files/ReplaceTags.pptx";
const string dstFileName = "../../files/ReplaceTags_removeinvalidxmlchars.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
// See UTF-8 encoding table and Unicode characters http://www.utf8-chartable.de/
// See Table of ASCII Characters http://web.cs.mun.ca/~michael/c/ascii-table.html
const string sub = "\u001A";
pptx.GetSlide(0).ReplaceTag("{{hello}}", "hexadecimal value 0x1A (SUB), is an invalid character: " + sub, PptxSlide.ReplacementType.Global);
const string esc = "\u001B";
pptx.GetSlide(0).ReplaceTag("{{hello}}", "hexadecimal value 0x1B (ESC), is an invalid character: " + esc, PptxSlide.ReplacementType.Global);
pptx.Close();
}
public void RemoveColumns()
{
const string srcFileName = "../../files/RemoveColumns.pptx";
const string dstFileName = "../../files/RemoveColumns_output.pptx";
// Remove some columns
{
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
PptxSlide slide = pptx.GetSlide(0);
PptxTable table = slide.FindTables("{{table1}}").First();
Assert.AreEqual(5, table.ColumnsCount());
Assert.AreEqual(30, table.CellsCount());
int[] columns = new int[] { 1, 3 };
table.RemoveColumns(columns);
Assert.AreEqual(3, table.ColumnsCount());
Assert.AreEqual(18, table.CellsCount());
pptx.Close();
this.AssertPptxEquals(dstFileName, 1, "Column 0 Column2 Column 4 Cell 1.0 Cell 1.2 Cell 1.4 Cell 2.0 Cell 2.2 Cell 2.4 Cell 3.0 Cell 3.2 Cell 3.4 Cell 4.0 Cell 4.2 Cell 4.4 Cell 5.0 Cell 5.2 Cell 5.4 ");
}
// Remove all the columns
{
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
PptxSlide slide = pptx.GetSlide(0);
PptxTable table = slide.FindTables("{{table1}}").First();
Assert.AreEqual(5, table.ColumnsCount());
Assert.AreEqual(30, table.CellsCount());
int[] columns = new int[] { 0, 1, 2, 3, 4 };
table.RemoveColumns(columns);
Assert.AreEqual(0, table.ColumnsCount());
Assert.AreEqual(0, table.CellsCount());
pptx.Close();
this.AssertPptxEquals(dstFileName, 1, " ");
}
}
private void ReplaceTables(string dstFileName, int table1NbRows, int table2NbRows, int table3NbRows)
{
const string srcFileName = "../../files/ReplaceTables.pptx";
File.Delete(dstFileName);
File.Copy(srcFileName, dstFileName);
Pptx pptx = new Pptx(dstFileName, FileAccess.ReadWrite);
// Change the tags before to insert rows
{
PptxSlide slide = pptx.GetSlide(0);
slide.ReplaceTag("{{hello}}", "HELLO!", PptxSlide.ReplacementType.NoTable);
}
// Change the pictures before to insert rows
{
const string picture1_replace_png = "../../files/picture1_replace.png";
const string picture1_replace_png_contentType = "image/png";
PptxSlide slide = pptx.GetSlide(2);
slide.ReplacePicture("{{picture1png}}", picture1_replace_png, picture1_replace_png_contentType);
}
PptxSlide slideTemplate = pptx.GetSlide(1);
List<PptxSlide> existingSlides = new List<PptxSlide>();
{
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>();
for (int i = 0; i < table1NbRows; i++)
{
PptxTable.Cell[] row = new[]
{
new PptxTable.Cell("{{cell1}}", "1." + i + ".1"),
new PptxTable.Cell("{{cell2}}", "1." + i + ".2"),
new PptxTable.Cell("{{cell3}}", "1." + i + ".3"),
new PptxTable.Cell("{{cell4}}", "1." + i + ".4"),
new PptxTable.Cell("{{cell5}}", "1." + i + ".5"),
new PptxTable.Cell("{{cell6}}", "1." + i + ".6")
};
rows.Add(row);
}
var table = slideTemplate.FindTables("{{table1}}").First();
var slidesCreated = Pptx.ReplaceTable_Multiple(slideTemplate, table, rows, existingSlides);
existingSlides.AddRange(slidesCreated);
}
{
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>();
for (int i = 0; i < table2NbRows; i++)
{
PptxTable.Cell[] row = new[]
{
new PptxTable.Cell("{{cell1}}", "2." + i + ".1"),
new PptxTable.Cell("{{cell2}}", "2." + i + ".2"),
new PptxTable.Cell("{{cell3}}", "2." + i + ".3"),
new PptxTable.Cell("{{cell4}}", "2." + i + ".4"),
new PptxTable.Cell("{{cell5}}", "2." + i + ".5"),
new PptxTable.Cell("{{cell6}}", "2." + i + ".6")
};
rows.Add(row);
}
var table = slideTemplate.FindTables("{{table2}}").First();
var slidesCreated = Pptx.ReplaceTable_Multiple(slideTemplate, table, rows, existingSlides);
existingSlides.AddRange(slidesCreated);
}
{
List<PptxTable.Cell[]> rows = new List<PptxTable.Cell[]>();
for (int i = 0; i < table3NbRows; i++)
{
PptxTable.Cell[] row = new[]
{
new PptxTable.Cell("{{cell1}}", "3." + i + ".1"),
new PptxTable.Cell("{{cell2}}", "3." + i + ".2"),
new PptxTable.Cell("{{cell3}}", "3." + i + ".3"),
new PptxTable.Cell("{{cell4}}", "3." + i + ".4"),
new PptxTable.Cell("{{cell5}}", "3." + i + ".5"),
new PptxTable.Cell("{{cell6}}", "3." + i + ".6")
};
rows.Add(row);
}
var table = slideTemplate.FindTables("{{table3}}").First();
var slidesCreated = Pptx.ReplaceTable_Multiple(slideTemplate, table, rows, existingSlides);
existingSlides.AddRange(slidesCreated);
}
slideTemplate.Remove();
pptx.Close();
}
public void FileFormatException()
{
Pptx pptx = new Pptx("../../files/picture1.png", FileAccess.Read);
pptx.Close();
}
public void GetNotes()
{
const string file = "../../files/GetNotes.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(4, nbSlides);
Assert.AreEqual(string.Empty, pptx.GetSlide(0).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(1).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(2).GetTitle());
Assert.AreEqual(string.Empty, pptx.GetSlide(3).GetTitle());
var slidesNotes = new Dictionary<int, string[]>();
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
IEnumerable<string> notes = slide.GetNotes();
slidesNotes.Add(i, notes.ToArray());
}
string[] expected = { "Bonjour", "{{comment1}}", "Hello", "1" };
CollectionAssert.AreEqual(expected, slidesNotes[0]);
expected = new string[] { "{{comment2}}", "2" };
CollectionAssert.AreEqual(expected, slidesNotes[1]);
expected = new string[] { };
CollectionAssert.AreEqual(expected, slidesNotes[2]);
// TODO Why "Comment çava ?" instead of "Comment ça va ?"
expected = new string[] { "Bonjour {{comment3}} Hello", "Comment çava ?", string.Empty, string.Empty, "Hola!", string.Empty, "4" };
CollectionAssert.AreEqual(expected, slidesNotes[3]);
pptx.Close();
}
public void GetTexts()
{
const string file = "../../files/GetTexts.pptx";
Pptx pptx = new Pptx(file, FileAccess.Read);
int nbSlides = pptx.SlidesCount();
Assert.AreEqual(3, nbSlides);
Assert.AreEqual("test1", pptx.GetSlide(0).GetTitle());
Assert.AreEqual("Title 1", pptx.GetSlide(1).GetTitle());
Assert.AreEqual("Title 2", pptx.GetSlide(2).GetTitle());
var slidesTexts = new Dictionary<int, string[]>();
for (int i = 0; i < nbSlides; i++)
{
PptxSlide slide = pptx.GetSlide(i);
IEnumerable<string> texts = slide.GetTexts();
slidesTexts.Add(i, texts.ToArray());
}
string[] expected = { "test1", "Hello, world!" };
CollectionAssert.AreEqual(expected, slidesTexts[0]);
expected = new string[]
{
"Title 1", "Bullet 1", "Bullet 2",
"Column 1", "Column 2", "Column 3", "Column 4", "Column 5",
"Line 1", string.Empty, string.Empty, string.Empty, string.Empty,
"Line 2", string.Empty, string.Empty, string.Empty, string.Empty,
"Line 3", string.Empty, string.Empty, string.Empty, string.Empty,
"Line 4", string.Empty, string.Empty, string.Empty, string.Empty
};
CollectionAssert.AreEqual(expected, slidesTexts[1]);
expected = new string[] { "Title 2", "Bullet 1", "Bullet 2", "Comment ça va ?" };
CollectionAssert.AreEqual(expected, slidesTexts[2]);
pptx.Close();
}