Problem with xlsx import

Problem with xlsx import - Why does this syntax not work - Messages

#1 Posted: 2/10/2025 10:46:46 AM
RegRetired

RegRetired

8 likes in 130 posts.

Group: User

The sm and the xlsx are in the same folder, yet it will not import data from the xlsx spreadsheet.

Here is the sm file
DAYS BETWEEN DATES.sm (2 KiB) downloaded 23 time(s).

Here is the xlsx file
DAYS BETWEEN DATES.xlsx (9 KiB) downloaded 20 time(s).

Thanks for any help.
Reg

By the way, I recently updated SMATH and am having problems. I can no longer click on an sm file and have it open in the updated version. I have to open it through the updated version and save it. I have many files, so this is a real disappointment.
Reg Curry Loveland, CO
#2 Posted: 2/10/2025 11:04:13 AM
RegRetired

RegRetired

8 likes in 130 posts.

Group: User

I found my syntax error.

However, if someone knows how to make the updated SMATH open a file created in the previous version and have SMATH automatically update it, that would really help.
Thansk
Reg Curry Loveland, CO
#3 Posted: 2/10/2025 6:59:32 PM
Davide Carpi

Davide Carpi

1415 likes in 2872 posts.

Group: Moderator

Wrote

However, if someone knows how to make the updated SMATH open a file created in the previous version and have SMATH automatically update it, that would really help.



You mean that the OS has lost the file association? (blank files which are asked to choose an application to open them?)
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
#4 Posted: 2/11/2025 3:55:48 AM
RegRetired

RegRetired

8 likes in 130 posts.

Group: User

No, it opens the file; however, this dialog box appears every time. If I open the file from SMATH and then save it, I no longer get this dialog box.🤷‍♂️

wgVjKV1vcvM2ylp8.png
Reg Curry Loveland, CO
#5 Posted: 2/11/2025 4:28:57 AM
RegRetired

RegRetired

8 likes in 130 posts.

Group: User

Davide,

It does not work even if I open the file in SMATH and save it. When I click on the file I also get this error box in addition to the above one. I have updated SMATH and that's when the problems started.

Screenshot 2025-02-10 132456.png

Should I uninstall SMATH and try to reinstall. It's been so long I have forgotten how to do that since I don't have the install file. When I select download on the update dialog box above, it does not tell me where the download is. It's not in my normal download location. So, I just installed it.

Anyway, I am very frustrated.

Thanks for your help.
Reg
Reg Curry Loveland, CO
#6 Posted: 2/11/2025 4:42:58 AM
RegRetired

RegRetired

8 likes in 130 posts.

Group: User

Davide,
I think I found the problem. Apparently, when I did the update, it created a second installation of SMATH. I removed the older one from control panel and that seems to have fixed the problem...as far as I can tell at this time.

I'm getting too old for all this. But, it keeps me out of the bars at night.
Reg Curry Loveland, CO
1 users liked this post
Davide Carpi 2/11/2025 4:55:00 AM
#7 Posted: 2/11/2025 4:59:47 AM
Davide Carpi

Davide Carpi

1415 likes in 2872 posts.

Group: Moderator

I'm glad you were able to fix it on your own. I don't think I could have figured that scenario myself.
If you like my plugins please consider to support the program buying a license; for personal contributions to me: paypal.me/dcprojects
  • New Posts New Posts
  • No New Posts No New Posts