# Data handling **URL:** https://scilab.discourse.group/c/specific-domains/data-handling/20.md [Latest](https://scilab.discourse.group/latest.md) · [Categories](https://scilab.discourse.group/categories.md) · [Tags](https://scilab.discourse.group/tags.md) --- ## [About the Data handling category](https://scilab.discourse.group/t/about-the-data-handling-category/26)
**Author:** [@mottelet](https://scilab.discourse.group/u/mottelet)\ **Replies:** 0
--- ## [xlsxRead does not work if file is open in Excel](https://scilab.discourse.group/t/xlsxread-does-not-work-if-file-is-open-in-excel/1213)
**Author:** [@nilrua](https://scilab.discourse.group/u/nilrua)\ **Replies:** 2\ **Last updated:** [September 4, 2026, 3:47pm UTC](https://scilab.discourse.group/t/xlsxread-does-not-work-if-file-is-open-in-excel/1213 "2026-09-04T15:47:13Z")
Hi ! I’m using the xlsxRead function introduced in the recent 2026.0.1 version, which simplify my work greatly, thank you developers ! However, it seems than it does not work if the file is open in Excel. I get the foll… --- ## [Protection of the names of Scilab core features, \`summary()\` case](https://scilab.discourse.group/t/protection-of-the-names-of-scilab-core-features-summary-case/1151)
**Author:** [@davcheze](https://scilab.discourse.group/u/davcheze)\ **Replies:** 3\ **Last updated:** [July 27, 2026, 11:49am UTC](https://scilab.discourse.group/t/protection-of-the-names-of-scilab-core-features-summary-case/1151 "2026-07-27T11:49:02Z")
Hi all, I give a try to recently introduced summary() for table in Scilab 2026.1.0 core functions and I noticed that the name is not protected : indeed I installed the Stixbox module through the (new nice) ATOMS interfa… --- ## [Large table handling and visualization](https://scilab.discourse.group/t/large-table-handling-and-visualization/1161)
**Author:** [@davcheze](https://scilab.discourse.group/u/davcheze)\ **Replies:** 1\ **Last updated:** [May 28, 2026, 2:33pm UTC](https://scilab.discourse.group/t/large-table-handling-and-visualization/1161 "2026-05-28T14:33:49Z")
Hi all, I’ve been noticing strange behaviours around large table tres as shown in screenshot: only the first variable is thrown short in the console, is this as expected? Another issue maybe related to previous: T… --- ## [Create a plot with time on x from a csv file](https://scilab.discourse.group/t/create-a-plot-with-time-on-x-from-a-csv-file/1122)
**Author:** [@David1](https://scilab.discourse.group/u/David1)\ **Replies:** 4\ **Last updated:** [February 16, 2026, 9:58pm UTC](https://scilab.discourse.group/t/create-a-plot-with-time-on-x-from-a-csv-file/1122 "2026-02-16T21:58:24Z")
Hello, I’ve a csv file wich contain a log with a timestamp like this Timestamp;CPU\_Usage\_Percent;Memory\_MB;Disk\_Read\_KBps;Disk\_Write\_KBps 2026-02-15 12:18:29;0,00;32;0,00;0,00 2026-02-15 12:18:29;0,00;32;0,00;0,00 2026… --- ## [Wireshark,Tshark](https://scilab.discourse.group/t/wireshark-tshark/947)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 11\ **Last updated:** [December 9, 2025, 2:58pm UTC](https://scilab.discourse.group/t/wireshark-tshark/947 "2025-12-09T14:58:49Z")
I have installed wireshark and there is a terminal Tshark exe, there. How do i manage, when the powershell opens the t-shark terminal, that i received the datas by echo or piping into the matrix? “cd C:\\Programme\\Wires… --- ## [0-D interpolation, piecewise constant function definition](https://scilab.discourse.group/t/0-d-interpolation-piecewise-constant-function-definition/308)
**Author:** [@davcheze](https://scilab.discourse.group/u/davcheze)\ **Replies:** 7\ **Last updated:** [October 6, 2025, 8:23am UTC](https://scilab.discourse.group/t/0-d-interpolation-piecewise-constant-function-definition/308 "2025-10-06T08:23:31Z")
dear all, I’d like simply to interpolate data following piecewise constant method, as illustrated in code below. I looked into available interpolation functions but I didn’t found proper configuration to do this. I woul… --- ## [Datetime and duration: new features to create a time vector](https://scilab.discourse.group/t/datetime-and-duration-new-features-to-create-a-time-vector/289)
**Author:** [@adeline.carnis](https://scilab.discourse.group/u/adeline.carnis)\ **Replies:** 7\ **Last updated:** [July 23, 2025, 11:43am UTC](https://scilab.discourse.group/t/datetime-and-duration-new-features-to-create-a-time-vector/289 "2025-07-23T11:43:02Z")
Do you know the features allowing to create a time vector and necessary for timeseries? Datetime datetime represents a point in time. How to write this date and time November 29, 2023 at 10:05:23 with datetime ? dt = … --- ## [Reading json file with empty objects](https://scilab.discourse.group/t/reading-json-file-with-empty-objects/1015)
**Author:** [@elepen](https://scilab.discourse.group/u/elepen)\ **Replies:** 2\ **Last updated:** [July 11, 2025, 2:28pm UTC](https://scilab.discourse.group/t/reading-json-file-with-empty-objects/1015 "2025-07-11T14:28:26Z")
When I am reading a json file that includes empty objects using fromJSON function, it crashes closing the application without any error message: test3.json: { "ingedient\_names" : \[ \[\], \[\] … --- ## [Wrong Plot of datas?](https://scilab.discourse.group/t/wrong-plot-of-datas/931)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 3\ **Last updated:** [April 30, 2025, 6:30am UTC](https://scilab.discourse.group/t/wrong-plot-of-datas/931 "2025-04-30T06:30:15Z")
Hi Scilab team i have a timeseries with every two second a ping made which gives 1ms back as i plot this timeseries with stacked plot, i get this: from where are coming those peaks? --- ## [Polyfit with Timeseries](https://scilab.discourse.group/t/polyfit-with-timeseries/917)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 6\ **Last updated:** [April 24, 2025, 2:45pm UTC](https://scilab.discourse.group/t/polyfit-with-timeseries/917 "2025-04-24T14:45:43Z")
Hi Scilab TEAM i have a problem with making polyfit on timeseries for making a polyfit i have to make the dates into a number (unix timebase) then i have the polyfit values that are extrvagant high, so only linear … --- ## [Export a table to a file](https://scilab.discourse.group/t/export-a-table-to-a-file/855)
**Author:** [@philipp](https://scilab.discourse.group/u/philipp)\ **Replies:** 3\ **Last updated:** [March 10, 2025, 7:22pm UTC](https://scilab.discourse.group/t/export-a-table-to-a-file/855 "2025-03-10T19:22:18Z")
Hello, I am not quite sure, if my question is a double of this: so I rather open a new topic. I have a table created with matrix2table(). Assume that it is possible to display the full table at the console, because… --- ## [Import csv file and create chart](https://scilab.discourse.group/t/import-csv-file-and-create-chart/850)
**Author:** [@frankdunn](https://scilab.discourse.group/u/frankdunn)\ **Replies:** 2\ **Last updated:** [March 4, 2025, 11:57am UTC](https://scilab.discourse.group/t/import-csv-file-and-create-chart/850 "2025-03-04T11:57:16Z")
I want to import a csv file and plot some of the column data. Is there a example how to do this. I could do it with the older import tool but uiimport is not the same as the older uiSpreadsheet. --- ## [Using lambda functions with timeseries](https://scilab.discourse.group/t/using-lambda-functions-with-timeseries/841)
**Author:** [@adeline.carnis](https://scilab.discourse.group/u/adeline.carnis)\ **Replies:** 0\ **Last updated:** [February 27, 2025, 9:29am UTC](https://scilab.discourse.group/t/using-lambda-functions-with-timeseries/841 "2025-02-27T09:29:35Z")
Lambda functions have been introduced into Scilab 2025.0.0. Did you used them with timeseries/table? Here are some examples of uses: dt = datetime(2025, 1, 1:31)'; temp\_max = \[9; 10; 4; 2; 11; 12; 7; 8; 11; 4; 4; 6; 4;… --- ## [\[Statistic\] Show Index number of Outliner in vector](https://scilab.discourse.group/t/statistic-show-index-number-of-outliner-in-vector/172)
**Author:** [@Smart](https://scilab.discourse.group/u/Smart)\ **Replies:** 14\ **Last updated:** [February 17, 2025, 4:33pm UTC](https://scilab.discourse.group/t/statistic-show-index-number-of-outliner-in-vector/172 "2025-02-17T16:33:37Z")
Hello, I have a matrix of measurement data, and one of the columns contains temperature measurements. Some of the data points contain outliers or anomalies. I’m currently using the Scilab Toolbox “samplestat” to filter … --- ## [Problem with "-" in Struct name](https://scilab.discourse.group/t/problem-with-in-struct-name/819)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 2\ **Last updated:** [February 13, 2025, 6:24am UTC](https://scilab.discourse.group/t/problem-with-in-struct-name/819 "2025-02-13T06:24:41Z")
Hi, i have a Struct FMS\_MQTT\_WS.data(i).payload(1) ans = \[struct\] with fields: noise-level = 53 now i want to access this struct FMS\_MQTT\_WS.data(i).payload(1).noise-level Unbekanntes Feld: noise. The proble he… --- ## [Timeseries - Strange behaviour of retime() function](https://scilab.discourse.group/t/timeseries-strange-behaviour-of-retime-function/712)
**Author:** [@Laurent](https://scilab.discourse.group/u/Laurent)\ **Replies:** 4\ **Last updated:** [November 14, 2024, 3:55pm UTC](https://scilab.discourse.group/t/timeseries-strange-behaviour-of-retime-function/712 "2024-11-14T15:55:48Z")
Dear Scilab user, I’m working on big 10-minutes meteorological data and I’m trying to use the retime function to get “daily means”. The function has a strange behaviour that I cannot understand. Here’s an example : -… --- ## [Strange Error in datetime()](https://scilab.discourse.group/t/strange-error-in-datetime/696)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 1\ **Last updated:** [November 4, 2024, 4:00pm UTC](https://scilab.discourse.group/t/strange-error-in-datetime/696 "2024-11-04T16:00:44Z")
I have this code i cannot upload because of policy but hier is a snippet: //Read JSON File from Dashboard Log filenameIn=fullfile(pathIn+nameIn+ending(1)); FMS\_MQTT\_WS=fromJSON(filenameIn,“file”); for i=1:size(FMS\_MQ… --- ## [How to display a Table in GUI or picture](https://scilab.discourse.group/t/how-to-display-a-table-in-gui-or-picture/690)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 2\ **Last updated:** [October 28, 2024, 6:21am UTC](https://scilab.discourse.group/t/how-to-display-a-table-in-gui-or-picture/690 "2024-10-28T06:21:34Z")
Lets say i have a table with some currencies on the left side and in the header mean and Deviation. the table is full of values. But now, how do i get the table into a GUI or into a Figure. Table is now shown only in REP… --- ## [Timeseries/table - Apply filter on columns](https://scilab.discourse.group/t/timeseries-table-apply-filter-on-columns/629)
**Author:** [@Laurent](https://scilab.discourse.group/u/Laurent)\ **Replies:** 7\ **Last updated:** [October 3, 2024, 7:54am UTC](https://scilab.discourse.group/t/timeseries-table-apply-filter-on-columns/629 "2024-10-03T07:54:20Z")
Dear Scilab community, I’ve been using Scilab for several years, but now, I’m learning how to use the new timeseries / table functions to handle big amount of data. I’m wondering how to get a new matrix or table from a… --- ## [Datetime index localisation in matrix with dsearch?](https://scilab.discourse.group/t/datetime-index-localisation-in-matrix-with-dsearch/642)
**Author:** [@davcheze](https://scilab.discourse.group/u/davcheze)\ **Replies:** 7\ **Last updated:** [September 17, 2024, 7:22am UTC](https://scilab.discourse.group/t/datetime-index-localisation-in-matrix-with-dsearch/642 "2024-09-17T07:22:12Z")
Hello all, when using datetime objects from experiment and simulation data outputs, I’m facing frequent situations where i need to localize an arbitrary sample time within another table of discrete datetimes and I found… --- ## [Working with netCDF files](https://scilab.discourse.group/t/working-with-netcdf-files/556)
**Author:** [@arctica](https://scilab.discourse.group/u/arctica)\ **Replies:** 9\ **Last updated:** [July 20, 2024, 4:31pm UTC](https://scilab.discourse.group/t/working-with-netcdf-files/556 "2024-07-20T16:31:16Z")
For anyone using netCDF files (e.g from GMT software), Scilab can readily now read and write such data using the HDF5 functionality. Use h5dump to se what datasets are present. A short code snippet to help show how to r… --- ## [Timeseries and Milliseconds](https://scilab.discourse.group/t/timeseries-and-milliseconds/423)
**Author:** [@pascal](https://scilab.discourse.group/u/pascal)\ **Replies:** 7\ **Last updated:** [July 8, 2024, 10:59am UTC](https://scilab.discourse.group/t/timeseries-and-milliseconds/423 "2024-07-08T10:59:22Z")
Hi, i have this code and wanted to make timestamps in millisecond, but shows no millisecond values. This is for fast measurements with timesteps inferior to 1s. I wanted to attach this file but firewall blocks, so i pas… --- ## [An example of reading a text file](https://scilab.discourse.group/t/an-example-of-reading-a-text-file/540)
**Author:** [@Pascal77](https://scilab.discourse.group/u/Pascal77)\ **Replies:** 3\ **Last updated:** [June 10, 2024, 7:12am UTC](https://scilab.discourse.group/t/an-example-of-reading-a-text-file/540 "2024-06-10T07:12:07Z")
The code is very simple. Read instruction is use according to the SCILAb help. The text file has 2 columns of 31 real numbers. It could be the (x,y) values of a dedicated math function: 0 2.718281828 1 1.648721271 2 1.… --- ## [Demonstration of the new uiimport instruction (SCILAB 2024.1.0)](https://scilab.discourse.group/t/demonstration-of-the-new-uiimport-instruction-scilab-2024-1-0/527)
**Author:** [@Pascal77](https://scilab.discourse.group/u/Pascal77)\ **Replies:** 0\ **Last updated:** [May 29, 2024, 8:35am UTC](https://scilab.discourse.group/t/demonstration-of-the-new-uiimport-instruction-scilab-2024-1-0/527 "2024-05-29T08:35:06Z")
This new instruction is a delight to use. Simply open the Applications menu from the console window, select Import data at the bottom of the drop-down menu, then select the csv file you wish to process in SCILAB. The fo… --- ## [Timeseries: Simple Use Case](https://scilab.discourse.group/t/timeseries-simple-use-case/253)
**Author:** [@adeline.carnis](https://scilab.discourse.group/u/adeline.carnis)\ **Replies:** 9\ **Last updated:** [March 23, 2024, 12:34pm UTC](https://scilab.discourse.group/t/timeseries-simple-use-case/253 "2024-03-23T12:34:39Z")
Have you seen that timeseries have been added in Scilab 2024.0.0? Here is a simple use case using COVID data from https://covid.ourworldindata.org. Read data Data that we wish to process is stored in a CSV file. Re… --- ## [Problem with loadmatfile](https://scilab.discourse.group/t/problem-with-loadmatfile/382)
**Author:** [@somogyvari](https://scilab.discourse.group/u/somogyvari)\ **Replies:** 3\ **Last updated:** [February 2, 2024, 10:47am UTC](https://scilab.discourse.group/t/problem-with-loadmatfile/382 "2024-02-02T10:47:45Z")
Hi! My problem is that loadmatfile (maybe the full matio lib) does not work for me in Scilab2024.0.0 under MacOS Sonoma 14.2.1 M1 chip. This is quite a significant problem, corrupting compatibility. I got this error m… --- ## [Scan matrix from clipboard instead of file](https://scilab.discourse.group/t/scan-matrix-from-clipboard-instead-of-file/316)
**Author:** [@Skogen](https://scilab.discourse.group/u/Skogen)\ **Replies:** 2\ **Last updated:** [January 3, 2024, 11:47am UTC](https://scilab.discourse.group/t/scan-matrix-from-clipboard-instead-of-file/316 "2024-01-03T11:47:04Z")
Normally i would import/scan a matrix from an external measurement system using the below line. Which works perfectly fine. x=fscanfMat(‘data.txt’); Is there a way to do the same, but read the matrix from the clipboard… --- ## [Bilinear interpolation on grid data](https://scilab.discourse.group/t/bilinear-interpolation-on-grid-data/155)
**Author:** [@philipp](https://scilab.discourse.group/u/philipp)\ **Replies:** 18\ **Last updated:** [December 21, 2023, 8:08pm UTC](https://scilab.discourse.group/t/bilinear-interpolation-on-grid-data/155 "2023-12-21T20:08:56Z")
Dear Experts, I guess it is a very simple task, but somehow I can not get my head around. There is some data regarding a sensor calibration. Calibration data consists of: reference temperature = x-axis sensor signa… --- ## [How to access the last indices in scilab vector?](https://scilab.discourse.group/t/how-to-access-the-last-indices-in-scilab-vector/296)
**Author:** [@Vimsrocz](https://scilab.discourse.group/u/Vimsrocz)\ **Replies:** 2\ **Last updated:** [December 14, 2023, 5:52pm UTC](https://scilab.discourse.group/t/how-to-access-the-last-indices-in-scilab-vector/296 "2023-12-14T17:52:01Z")
There is “…end” function for MATLAB but there is anything for Scilab ? B\_orig = reshape(C(prod(size\_A)+1:end), size\_B); Here there is end use to access the last the elements of the vector. So anyone can guide me? funct… [Next page](https://scilab.discourse.group/c/specific-domains/data-handling/20.md?page=1)