![]() ![]() Graph: added the "No Labels On Y-Axis" option for dataset 2. Set Entire Column: the dialog now allows the user to choose which column will be affected. This allows you to force the Y-Axis for dataset 2 to cover the same range as dataset 1. Split Column: added an option that controls if the separator is deleted, left in the source column, or left in the new column. Graph: each CSV file now maintains a separate set of the settings that appear on the Graph configuration window. ![]() Paste Column: there is now an option to paste data starting at the row with focus rather than the top. Set Entire Column: added the ability to perform a mathematical operation on each cell. The Print Preview window also adds some new capabilities, such as Landscape orientation, customizable header and footer, and adjustable margins.Īdded to the Options menu tools for resetting the toolbar to two themes, one with text labels and one without. When restoring the previous session, the "File is completely empty" warning is now suppressed.įixed: if a popup window is created while the parent window is minimized, it could appear on the wrong monitor.Īdded a tool for generating a Histogram from CSV data.Īdded support for Print Preview. The buttons on the last window of the Graph tool now match those from the Pie Chart tool. Help file: Search tab: added two buttons that allow you to jump to the next/previous search occurrence. Help file: added a chapter on the "Cell" menu. Shift Cells Left/Right: the Preview now includes the "#" column. The "Select All Rows" tool now has a hotkey, Ctrl Shift A. Toolbar: added the ability to place a "Column Sort Method" icon on the toolbar, although it is hidden by default. It is useful for testing the Histogram tool.įile Properties: if the "No Column Names" box is checked, and all column names are blank, the columns will be named "A", "B", "C", etc. Split Column: the "Keep Separator" field is now remembered.Ī file named "Example Histogram.csv" is now installed. Spell Check Table: this now reports the total number of cells that were spell checked. ![]() Set Entire Column: Perform Math: added the ability to calculate an exponential. Table Statistics: for numeric columns, the minimum and maximum values are now reported. Pie Chart: added a "Reset Colors" button to the second window.Įxport JSON: added the option of exporting as rows containing each column, rather than columns containing each row. Pie Chart: the Decimal Digits setting can now be negative, in which case the absolute value is used, except that trailing zeros are trimmed. Pie Chart: the slice colors are now remembered. Histogram: added the "Draw Horizontal Lines" option. Histogram: added the ability to control the number of digits after the decimal point for X-axis values. Histogram: added the ability to place a text label on the Y-axis. Graph: added the ability to control the minimum value of the Y-axis. Previously they were always below the graph. Graph: added the ability to place the X-axis units above each data point. Previously only dates or numbers were supported. Graph: it is now possible to put text labels on the X-axis. Print: there is now a checklist of the columns that will be printed. However, please note that this only happens if the file has been saved at least once in the past.įilter: Conditional mode: added support for parenthesis. Previously these preferences were only recorded if the file was saved. When a file is closed, minor table preferences are now recorded, including the column widths, column sorting, sort method, and focus cell. When a file is opened for the first time, the Sort Method of each column will be auto-detected by examining the contents of the first 100 rows. Use League\Csv\Reader use League\Csv\XMLConverter //load the CSV document from a SplFileObject $file = new SplFileObject ( '/path/to/your/csv/file.csv', 'r' ) $csv = Reader :: createFromFileObject ( $file ) $converter = XMLConverter :: create () -> rootElement ( 'csv' ) -> recordElement ( 'record', 'offset' ) -> fieldElement ( 'field', 'name' ) $dom = $converter -> convert ( $csv ) $dom -> formatOutput = true $dom -> encoding = 'iso-8859-15' echo '', PHP_EOL echo htmlentities ( $dom -> saveXML ()) // // //. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |