Пример #1
0
        public void CreateTableFormatedText()
        {
            //Create new spreadsheet document
            SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();

            spreadsheetDocument.New();
            //Create a new table
            Table table = new Table(spreadsheetDocument, "First", "tablefirst");
            //Create a new cell, without any extra styles
            Cell cell = table.CreateCell();
            //cell.OfficeValueType					= "string";
            //Set full border
            //cell.CellStyle.CellProperties.Border	= Border.NormalSolid;
            //Add a paragraph to this cell
            Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(
                spreadsheetDocument);
            //Create some Formated text
            FormatedText fText = new FormatedText(spreadsheetDocument, "T1", "Some Text");

            //fText.TextStyle.TextProperties.Bold		 = "bold";
            fText.TextStyle.TextProperties.Underline = LineStyles.dotted;
            //Add formated text
            paragraph.TextContent.Add(fText);
            //Add paragraph to the cell
            cell.Content.Add(paragraph);
            //Insert the cell at row index 2 and column index 3
            //All need rows, columns and cells below the given
            //indexes will be build automatically.
            table.InsertCellAt(2, 3, cell);
            //Insert table into the spreadsheet document
            spreadsheetDocument.TableCollection.Add(table);
            spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "formated.ods");
        }
Пример #2
0
        public void ComplexCalcLoadTest()
        {
            string   file  = AARunMeFirstAndOnce.inPutFolder + @"HazelHours.ods";
            FileInfo fInfo = new FileInfo(file);
            //Load a spreadsheet document
            SpreadsheetDocument document = new SpreadsheetDocument();

            try
            {
                document.Load(file);
                //Save it back again
                document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
            }
            catch (Exception ex)
            {
                if (ex is AODLException)
                {
                    Console.WriteLine("Stacktrace: {0}", ((AODLException)ex).OriginalException.StackTrace);
                    Console.WriteLine("Msg: {0}", ((AODLException)ex).OriginalException.Message);
                    if (((AODLException)ex).Node != null)
                    {
                        Console.WriteLine("Stacktrace: {0}", ((AODLException)ex).Node.OuterXml);
                    }
                }
            }
        }
Пример #3
0
        public void CsvToOpenDocumentSpreadsheet()
        {
            SpreadsheetDocument document = new SpreadsheetDocument();

            document.Load(AARunMeFirstAndOnce.inPutFolder + "CsvToOpenDocument.csv");
            Assert.IsTrue(document.Content.Count == 1, "Must contain objects.");
            document.SaveTo(AARunMeFirstAndOnce.outPutFolder + "CsvToOpenDocument.ods");
        }
Пример #4
0
        public void ComplexCalcLoadTest()
        {
            string   file  = AARunMeFirstAndOnce.inPutFolder + @"HazelHours.ods";
            FileInfo fInfo = new FileInfo(file);
            //Load a spreadsheet document
            SpreadsheetDocument document = new SpreadsheetDocument();

            document.Load(file);
            //Save it back again
            document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
        }
Пример #5
0
        public void HTMLExportTest3()
        {
            string   file  = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
            FileInfo fInfo = new FileInfo(file);
            //Load a spreadsheet document
            SpreadsheetDocument document = new SpreadsheetDocument();

            document.Load(file);
            //Save it back again
            document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".html");
        }
Пример #6
0
        public void TestLengend()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
            Chart chart = (Chart)doc.EmbedObjects [0];

            chart.ChartLegend.LegendPosition = "left";
            chart.ChartLegend.SvgX           = "5cm";
            chart.ChartLegend.SvgY           = "2cm";
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestLegend.ods"));
        }
Пример #7
0
        public void LoadChartModifyTitle()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
            IContent iContent = (EmbedObject)doc.EmbedObjects [0];

            ((Chart)iContent).ChartTitle.SetTitle("A New Title");
            ((Chart)iContent).ChartTitle.SvgX = "2cm";
            ((Chart)iContent).ChartTitle.SvgY = "0.5cm";
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestTitle.ods"));
        }
Пример #8
0
        public void NewChartWithCellRange()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
            Table table = doc.TableCollection[0];
            Chart chart = ChartBuilder.CreateChartByCellRange(table, "A4:F8", ChartTypes.bar, null, null, "刘玉花的测试", 3, "bottom", "P14");

            table.InsertChartAt("H2", chart);
            doc.Content.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithCellRange.ods"));
        }
Пример #9
0
        public void NewChartWithLegend()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
            Table table = doc.TableCollection[0];
            Chart chart = ChartBuilder.CreateChartByLegend(table, "A3:F8", ChartTypes.surface, "left", "0.5", "5", "year", "dollars");

            table.InsertChartAt("M2", chart);
            doc.Content.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithLegend.ods"));
        }
Пример #10
0
        public void NewChartWithAxises()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
            Table table = doc.TableCollection[0];
            Chart chart = ChartBuilder.CreateChartByAxises(table, "A1:B2", ChartTypes.line, 2);

            table.InsertChartAt("I2", chart);
            doc.Content.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithAxis.ods"));
        }
Пример #11
0
        public void SpreadSheetFormsTest()
        {
            //Create new spreadsheet document
            SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();

            spreadsheetDocument.New();
            //Create a new table
            Table table = new Table(spreadsheetDocument, "First", "tablefirst");
            //Create a new cell, without any extra styles
            Cell cell = new Cell(spreadsheetDocument, "cell001");

            cell.OfficeValueType = "string";
            //Set full border
            cell.CellStyle.CellProperties.Border = Border.NormalSolid;
            //Add a paragraph to this cell
            Paragraph paragraph = ParagraphBuilder.CreateSpreadsheetParagraph(
                spreadsheetDocument);

            //Add some text content
            paragraph.TextContent.Add(new SimpleText(spreadsheetDocument, "Some text"));
            //Add paragraph to the cell
            cell.Content.Add(paragraph);
            //Insert the cell at row index 2 and column index 3
            //All need rows, columns and cells below the given
            //indexes will be build automatically.
            table.Rows.Add(new Row(table, "Standard"));
            table.Rows.Add(new Row(table, "Standard"));
            table.Rows.Add(new Row(table, "Standard"));
            table.InsertCellAt(3, 2, cell);
            //Insert table into the spreadsheet document

            ODFForm main_form = new ODFForm(spreadsheetDocument, "mainform");

            main_form.Method = Method.Get;
            ODFButton butt = new ODFButton(main_form, cell.Content, "butt", "0cm", "0cm", "15mm", "8mm");

            butt.Label = "test :)";
            main_form.Controls.Add(butt);
            spreadsheetDocument.TableCollection.Add(table);
            table.Forms.Add(main_form);

            spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms.ods");

            SpreadsheetDocument spreadsheetDocument2 = new SpreadsheetDocument();

            spreadsheetDocument2.Load(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms.ods");
            ODFButton b = spreadsheetDocument2.TableCollection[0].FindControlById("butt") as ODFButton;

            Assert.IsNotNull(b);
            b.Label = "it works!";
            spreadsheetDocument2.SaveTo(AARunMeFirstAndOnce.outPutFolder + "spreadsheet_forms2.ods");
        }
Пример #12
0
        public void TestPlotArea()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
            Chart chart = (Chart)doc.EmbedObjects [0];

            chart.ChartPlotArea.SvgX   = "1.2cm";
            chart.ChartPlotArea.SvgY   = "2.5cm";
            chart.ChartPlotArea.Width  = "5cm";
            chart.ChartPlotArea.Height = "5cm";
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "TestPlotArea.ods"));
        }
Пример #13
0
        public void SpreadSheetImportExportTest()
        {
            //Create new spreadsheet document
            SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();

            spreadsheetDocument.Load(AARunMeFirstAndOnce.inPutFolder + @"bigtable.ods");
            ODFForm   f    = new ODFForm(spreadsheetDocument, "mainform");
            ODFButton butt = new ODFButton(f, spreadsheetDocument.TableCollection[0].Rows[1].Cells[1].Content, "butt", "5mm", "15mm", "4cm", "1cm");

            f.Controls.Add(butt);
            spreadsheetDocument.TableCollection[0].Forms.Add(f);
            spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "bigtable2.ods");
        }
Пример #14
0
        public void SimpleCalcLoadTest()
        {
            string   file  = AARunMeFirstAndOnce.inPutFolder + @"simpleCalc.ods";
            FileInfo fInfo = new FileInfo(file);
            //Load a spreadsheet document
            SpreadsheetDocument document = new SpreadsheetDocument();

            document.Load(file);
            Assert.IsTrue(document.CommonStyles.Count > 0, "Common Styles must be read!");
            Console.WriteLine("Common styles: {0}", document.CommonStyles.Count);
            //Save it back again
            document.SaveTo(AARunMeFirstAndOnce.outPutFolder + fInfo.Name + ".rel.ods");
        }
Пример #15
0
        public void LoadChart()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"TestChartOne.ods"));
            IContent iContent = (EmbedObject)doc.EmbedObjects [0];

            ((Chart)iContent).ChartType = ChartTypes.bar.ToString();
            ((Chart)iContent).XAxisName = "XAxis";
            ((Chart)iContent).YAxisName = "YAxis";
            ((Chart)iContent).SvgWidth  = "20cm";
            ((Chart)iContent).SvgHeight = "20cm";
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "LoadChart.ods"));
        }
Пример #16
0
        public void NewChartWithTitle()
        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.Load(Path.Combine(AARunMeFirstAndOnce.inPutFolder, @"testsheet.ods"));
            Table table = doc.TableCollection[0];
            Chart chart = ChartBuilder.CreateChartByTitle(table, "A3:E7", ChartTypes.stock, "北京红旗中文两千公司九月工资报表", "0.5cm", "0.5cm", null, null);

            chart.ChartTitle.TitleStyle.TextProperties.FontSize = "3pt";
            chart.EndCellAddress = table.TableName + ".P17";
            table.InsertChartAt("I2", chart);
            doc.Content.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "NewChartWithTitle.ods"));
        }
Пример #17
0
        public void CreateNewSpreadsheet()
        {
            SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();

            spreadsheetDocument.New();
            Assert.IsNotNull(spreadsheetDocument.DocumentConfigurations2);
            Assert.IsNotNull(spreadsheetDocument.DocumentManifest);
            Assert.IsNotNull(spreadsheetDocument.DocumentPictures);
            Assert.IsNotNull(spreadsheetDocument.DocumentThumbnails);
            Assert.IsNotNull(spreadsheetDocument.DocumentSetting);
            Assert.IsNotNull(spreadsheetDocument.DocumentStyles);
            Assert.IsNotNull(spreadsheetDocument.TableCollection);
            spreadsheetDocument.SaveTo(AARunMeFirstAndOnce.outPutFolder + "blank.ods");
            Assert.IsTrue(File.Exists(AARunMeFirstAndOnce.outPutFolder + "blank.ods"));
        }
Пример #18
0
        public void NewBasicChartThenSetTitle()
        {
            string expected         = "Basic Chart";
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.New();
            Table table = new Table(doc, "tab1", "tab1");

            for (int i = 1; i <= 1; i++)
            {
                for (int j = 1; j <= 6; j++)
                {
                    Cell cell = table.CreateCell();
                    cell.OfficeValueType = "float";
                    Paragraph paragraph = new Paragraph(doc);
                    string    text      = (j + i - 1).ToString();
                    paragraph.TextContent.Add(new SimpleText(doc, text));
                    cell.Content.Add(paragraph);
                    cell.OfficeValueType = "string";
                    cell.OfficeValue     = text;
                    table.InsertCellAt(i, j, cell);
                }
            }
            Chart      basicChart = ChartBuilder.CreateChart(table, ChartTypes.line, "A4:F8");
            ChartTitle ct         = new ChartTitle(basicChart);

            //ct.InitTitle();
            ct.SetTitle(expected);
            Assert.AreEqual(expected, ((Paragraph)ct.Content[0]).TextContent[0].Text);
            basicChart.ChartTitle = ct;
            IContent chartTitleContent = null;

            chartTitleContent = basicChart.Content.Find(o => o is ChartTitle);
            if (chartTitleContent == null)
            {
                foreach (IContent iContent in basicChart.Content)
                {
                    if (iContent is ChartTitle)
                    {
                        chartTitleContent = iContent;
                    }
                }
            }
            Assert.AreEqual(expected, ((Paragraph)((ChartTitle)chartTitleContent).Content[0]).TextContent[0].Text);
            table.InsertChartAt("H2", basicChart);
            doc.TableCollection.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, "BasicChartWithTitlesetafterwards.ods"));
        }
Пример #19
0
        /// <summary>
        ///
        /// </summary>
        public FileDocumento SaveAndExportData()
        {
            FileDocumento file     = new FileDocumento();
            bool          retValue = false;

            document.SaveTo(filePath);

            //Codice per generare l'export del file

            try
            {
                //string temporaryXSLFilePath = string.Empty;
                StreamWriter  writer = null;
                StringBuilder sb     = new StringBuilder();

                //Salva e chiudi il file
                //temporaryXSLFilePath = HttpContext.Current.Server.MapPath(filePath);
                //Crea il file
                FileStream stream = new FileStream(filePath, FileMode.Open, FileAccess.Read);
                if (stream != null)
                {
                    byte[] contentODS = new byte[stream.Length];
                    stream.Read(contentODS, 0, contentODS.Length);
                    stream.Flush();
                    stream.Close();
                    stream              = null;
                    file.content        = contentODS;
                    file.length         = contentODS.Length;
                    file.estensioneFile = "ods";
                    file.name           = "ExportDocumenti";
                    file.contentType    = "application/vnd.oasis.opendocument.spreadsheet";
                }
                retValue = true;
            }
            catch (Exception e)
            {
                // this.file = null;
                logger.Debug("Errore esportazione documenti : " + e.Message);
            }

            File.Delete(filePath);

            return(file);
        }
Пример #20
0
        public void CreateNewChart()

        {
            SpreadsheetDocument doc = new SpreadsheetDocument();

            doc.New();
            Table table = new Table(doc, "tab1", "tab1");

            for (int i = 1; i <= 1; i++)
            {
                for (int j = 1; j <= 6; j++)
                {
                    Cell cell = table.CreateCell();
                    cell.OfficeValueType = "float";
                    Paragraph paragraph = new Paragraph(doc);
                    string    text      = (j + i - 1).ToString();
                    paragraph.TextContent.Add(new SimpleText(doc, text));
                    cell.Content.Add(paragraph);
                    cell.OfficeValueType = "string";
                    cell.OfficeValue     = text;
                    table.InsertCellAt(i, j, cell);
                }
            }

            Chart chart = ChartBuilder.CreateChartByAxisName
                              (table, ChartTypes.bar, "A1:E4", "years", "dollars");

            Assert.AreEqual(7, table.Rows[1].Cells.Count);
            Assert.AreEqual(6, table.Rows[2].Cells.Count);
            Assert.AreEqual(6, table.Rows[3].Cells.Count);
            Assert.AreEqual(6, table.Rows[4].Cells.Count);

            /*Chart chart = new Chart (table,"ch1");
             * chart.ChartType=ChartTypes.bar .ToString () ;
             * chart.XAxisName ="yeer";
             * chart.YAxisName ="dollar";
             * chart.CreateFromCellRange ("A1:E4");
             * chart.EndCellAddress ="tab1.K17";*/
            table.InsertChartAt("G2", chart);

            doc.Content.Add(table);
            doc.SaveTo(Path.Combine(AARunMeFirstAndOnce.outPutFolder, @"NewChartOne.ods"));
        }
Пример #21
0
        void Supl(int id) //бланк в разрезе по поставщикам, поэтому функция для фильтрации объектов того или иного поставщика
        {
            SpreadsheetDocument spreadsheetDocument = new SpreadsheetDocument();

            spreadsheetDocument.New();
            Table table = new Table(spreadsheetDocument, "First", "tablefirst");

            for (int j = 0; j < countsup; j++)
            {
                Paragraph parag = ParagraphBuilder.CreateSpreadsheetParagraph(spreadsheetDocument);
                var       text  = TextBuilder.BuildTextCollection(spreadsheetDocument, " ");
                Cell      cell  = table.CreateCell();
                parag.TextContent.Add(new SimpleText(spreadsheetDocument, "элемент бд, где поставщик ид=ид"));//И за это тоже выебу и в прямом, и в переносном смысле за такие фразы
                cell.Content.Add(parag);
                table.InsertCellAt(0, 0, cell);
                spreadsheetDocument.TableCollection.Add(table);
                spreadsheetDocument.SaveTo("Matr.ods");
            }
        }
Пример #22
0
        /// <summary>
        /// Metodo per la generazione di un report ODS
        /// </summary>
        /// <param name="request">Informazioni sul report da produrre</param>
        /// <param name="reports">Report da esportare</param>
        /// <returns>Foglio di calcolo Open Office</returns>
        public FileDocumento GenerateReport(PrintReportRequest request, List <DocsPaVO.Report.Report> reports)
        {
            // Instanziazione del writer ODS e creazione del documento
            SpreadsheetDocument spreadSheetDocument = new SpreadsheetDocument();

            spreadSheetDocument.New();



            // Generazione di un foglio per ogni report
            foreach (var report in reports)
            {
                // Generazione di un foglio con i dati contenuti nel report
                this.AddWorksheet(spreadSheetDocument, report, request.ReportKey);
            }

            // Inizializzazione del file name
            String fileName = String.Format("Report_{0}.ods", DateTime.Now.ToString("dd-MM-yyyy"));

            // Inizializzazione del path del file
            String filePath;

            if (!String.IsNullOrEmpty(DocsPaUtils.Configuration.InitConfigurationKeys.GetValue("0", "BE_TEMP_PATH")))
            {
                filePath = Path.Combine(
                    DocsPaUtils.Configuration.InitConfigurationKeys.GetValue("0", "BE_TEMP_PATH"),
                    String.Format(@"AODF\{0}", Guid.NewGuid()));
            }
            else
            {
                filePath = Path.Combine(
                    Environment.GetFolderPath(Environment.SpecialFolder.InternetCache),
                    String.Format(@"AODF\{0}", Guid.NewGuid()));
            }

            //String filePath = Path.Combine(
            //    Environment.GetFolderPath(Environment.SpecialFolder.InternetCache),
            //    String.Format(@"AODF\{0}", Guid.NewGuid()));

            // Creazione della cartella
            DirectoryInfo dirInfo = Directory.CreateDirectory(filePath);

            // Salvataggio del file Open Document
            spreadSheetDocument.SaveTo(Path.Combine(filePath, fileName));

            // Generazione del risultato dell'export
            FileDocumento document = new FileDocumento();

            using (MemoryStream stream = new MemoryStream(File.ReadAllBytes(Path.Combine(filePath, fileName))))
            {
                document.name        = fileName;
                document.path        = String.Empty;
                document.fullName    = document.name;
                document.contentType = "application/vnd.oasis.opendocument.spreadsheet";
                document.content     = new Byte[stream.Length];

                stream.Read(document.content, 0, document.content.Length);

                stream.Flush();
                stream.Close();
            }

            // Si provano a cancellare File e cartella
            this.DeleteTemporaryData(dirInfo);

            return(document);
        }