Community Profile

Joanna Przeworska

Last seen: 1 month ago
22 total contributions since 2021

View details...

Contributions in
View by

Question

I would like to download this file: https://www.nbp.pl/en/statystyka/m3/podaz_bilansowa_en.xlsx and save it in the folder, all u...

1 month ago | 1 answer | 0

1

Question

How to convert this 'out_17-May-2021.xlsx' into 'out_20210517.xlsx'?
Dear all, How to convert this (below) into 'out_20210517'? filename = sprintf('out_%s.xlsx', today('datetime')); filename = ...

1 month ago | 2 answers | 0

2

Question

Save Matlab data in Excel with ActiveX
Hello, I need your help as I am not very experienced in linking with Excel through ActiveX. Below I attach the code I managed t...

2 months ago | 1 answer | 0

1

Question

Conversion from string to numbers within table
Hi, I have table with data (attached below), which I want to convert from string to numbers and store as the same table. Is the...

2 months ago | 1 answer | 0

1

Question

Why 'PreserveFormat' in writetable returns error?
Hi, I have a code: writetable(SECTORS.NFC.Total,'Wyniki_2020_12.xlsx','Sheet','NFC','Range','B9:L77','PreserveFormat',true,'Wr...

3 months ago | 1 answer | 0

1

Question

Refer to structure names
Hi, Suppose I have a structure A with a, b, c, d tables inside. My aim is to use names of tables within structure A (a, b, c, d...

3 months ago | 3 answers | 0

3

Question

Moving sum of 4 subsequent observatins
How can I get the moving sum of 4 subsequent observations out of variable 'var'? In specific, I would like the new variable to b...

3 months ago | 2 answers | 0

2

Question

How to sum structures
Dear all, Suppose I have two structures A and B, which inside have the same substructures a, b, c, d, e and each of substructur...

3 months ago | 1 answer | 0

1

Coverting specific string containing date to datetime
Dear Cris and Stephen, Thank you for your suggestions. Kind regards, JP

4 months ago | 0

Question

Coverting specific string containing date to datetime
Dear all, Let say I have a dataset with the variable 'Period', which want to convert to a datetime: 2012-12-01; 2013-03-01, 201...

4 months ago | 2 answers | 0

2

Question

Save structure in Excel
Dear all, I have a structure, which I want to save in Excel, in a way that each table is saved in different Excel sheet. Could ...

4 months ago | 1 answer | 0

1

How to create a structure of matrices within a loop
Dear Stephen, Thank you for your response, however when I implement your idea I get an error: 'Argument to dynamic structure re...

4 months ago | 0

Question

How to create a structure of matrices within a loop
Dear all, Using the following code, I would like to create a structure containing 3 matrices that are the result of a loop. I w...

4 months ago | 2 answers | 0

2

Looping over paths, more than one loop
Dear Jan, This idea helps me a lot and solves all my problems related to this exercise. Thank you very much for your assista...

4 months ago | 0

Looping over paths, more than one loop
Dear Bob, Thank you for your response. Basically, I want to get the same result as presented, but I would like to store the p...

4 months ago | 0

Question

Looping over paths, more than one loop
Dear all, suppose I have a vector of names: vectorOfNames = {'A','B','C'}; and my goal is to iterate through this vector fo...

4 months ago | 3 answers | 0

3

Switching to further part of code from conditional statement 'if'
Dear Walter, Thank you for this solution. This is exactly what I was looking for. Kind regards, Joanna

4 months ago | 0

| accepted

Switching to further part of code from conditional statement 'if'
Yes, this solution could work, however I forgot to add one piece of code, which is in conditional statement before the part of c...

5 months ago | 0

Question

Switching to further part of code from conditional statement 'if'
Suppose I have the following structure of code (below). The point is, in 2 different parts of my program I have exactly the same...

5 months ago | 3 answers | 0

3

How to convert numeric date into format 'dd-mmm-yyyy' (e.g. 01-mar-1970)
Dear Walter and Steven, Thank you for your suggestions. I implement one of them for sure. Best regards, JP

5 months ago | 0

| accepted

How to convert numeric date into format 'dd-mmm-yyyy' (e.g. 01-mar-1970)
Dear Walter, Thanks a lot for your suggestion. This solution works perfectly fine when I create a new variable. However, my go...

5 months ago | 0

Question

How to convert numeric date into format 'dd-mmm-yyyy' (e.g. 01-mar-1970)
Hi, Suppose I have a double 10x2 that contains numeric dates in the first column and numbers in the second, like below. My goa...

5 months ago | 3 answers | 1