Adiciona documentação para os métodos de formatação condicional: DataBar e IconSet. Atualiza o método FormatCond com informações sobre formatação condicional avançada.
Atualiza documentação dos métodos de leitura e abertura de arquivos Excel, incluindo exemplos e tratamento de erros. Adiciona novos métodos e aprimora a descrição de funcionalidades.
Atualiza documentação sobre tipos de gráficos e métodos de criação, incluindo novos atalhos e exemplos de uso.
Add documentation for various chart types and methods in the ADVPL Excel library - Created documentation for ChartBar, ChartBubble, ChartCombo, ChartDoughnut, ChartLine, ChartPie, ChartScatter, and ChartSurface. - Added method documentation for Insert, Set3D, SetTitulo, and NewChart. - Included examples for each chart type demonstrating usage and configuration. - Clarified limitations and specific behaviors for 3D charts and combinations.
Add new methods and enhance existing documentation for Excel manipulation - Introduced SetColLevel method for defining column grouping levels. - Added SetDateTime method for setting date and time in cells. - Implemented SetHeader and SetFooter methods for configuring print headers and footers. - Created SetPagOrientation method to define page orientation for printing. - Added SetPlanAt method for positioning in existing sheets by index or name. - Implemented SetPrintArea and SetPrintTitles methods for defining print areas and titles. - Introduced SetRowH method for setting row heights. - Added SetStyle method for applying styles to cells or ranges. - Implemented SetValueBulk method for bulk value insertion. - Enhanced cell manipulation methods (Cell, GetValue) to use custom.excel.Xlsx. - Added mergeCells method for merging cell ranges. - Updated New method to include processing type options. - Enhanced NewStyle method for style creation. - Updated Pos and PosR methods to support chaining. - Added showGridLines method to toggle grid line visibility. - Enhanced cell protection methods for better usability.
Alterado nome da classe YExcel para custom.excel.Xlsx e ajustada descrição da planilha
Updated method newstyle (markdown)
Updated _Sidebar (markdown)
Created method-cellprotection (markdown)
Updated method‐setsheetProtection (markdown)
Updated SetsheetProtection (markdown)
Created SetsheetProtection (markdown)
Created method getvalue (markdown)
Updated method setvalue (markdown)
Updated Home (markdown)
Created Exemplo ler planilha (markdown)
Updated method LocRef (markdown)
Updated method Ref (markdown)
Updated method Borda (markdown)
Updated method Alinhamento (markdown)
Updated method EfeitoPreenc (markdown)