Jump to content
deanishe

I Sheet You Not: Plug Excel into Alfred

Recommended Posts

Hello! This workflow is absolutely ridiculous, unbelievably useful- so thank you once again, @deanishe! It almost made me throw my keyboard out the window when I realized how easy and powerful this could be.

 

So after diving in, I have two questions:

 

  1. Is it possible to use multiple columns in one of the fields (title, subtitle)? The motivation here is to quickly see more info from the spreadsheet, but also to not have to 'fix it' with formulas on the spreadsheet itself.
     
  2. Is there a good way to set the MATCH variable to only match if it is an exact result? I only need this for instances where I'm passing a number to the spreadsheet, but if I pass '1' to it, it's currently finding 12, 133, etc. I tried looking up the python formatting that you link to in your documentation, but it's all a bit over my head.

Thanks so much!

 

Share this post


Link to post
6 hours ago, joeynotjoe said:

Is it possible to use multiple columns in one of the fields (title, subtitle)?

 

No, afraid not.

 

6 hours ago, joeynotjoe said:

Is there a good way to set the MATCH variable to only match if it is an exact result?

 

Also no, I’m afraid. Alfred is filtering the results, not the workflow. It doesn’t know anything about numbers, so the query “1” means “words starting with the character ‘1’”.

 

Share this post


Link to post

Hi !

I am very very interested in this tool as I am a heavy Excel user, and I believe it would make me gain a lot of time.
I cannot get it to work with Alfred 4 though. I read through this thread quickly but I don't think this has been discussed.

Is this workflow compatible with Alfred 4 ?

 

I cannot populate the fields "Date_format" / "Doc_path" ... as whenever I write something in there it goes blank as soon as I press enter.

Also, when I try to create a workflow with iSyn, whenever I select an excel file it does not create the workflow.

 

Any help is appreciated :)


Thanks !

Share this post


Link to post

I haven't really tested this workflow with Alfred 4, but I believe it should be compatible.

 

1 hour ago, Flow said:

I cannot populate the fields "Date_format" / "Doc_path" ... as whenever I write something in there it goes blank as soon as I press enter.

 

That should definitely not happen. It sounds like you may have a permissions issue, i.e. Alfred can't write to the workflow's info.plist.

 

Which version of macOS are you running? Have you tried deleting and re-installing the workflow?

Share this post


Link to post

I am running MacOS 10.12.6 (Sierra)

Alfred 4 fully up to date. Should I revert to Alfred 3 maybe ?

In other workflows I have the same issue of not being able to write in those fields.

I have tried reinstalling the workflow multiple times, yes.

If I can give you any more information, please tell me.

 

Alfred is authorised to modify stuff on my computer :

 

Screen-Capture-1.png

Share this post


Link to post
7 minutes ago, Flow said:

I have tried reinstalling the workflow multiple times, yes.

 

And what happened?

 

Like I said, it sounds like you have a permissions issue. That means the files are not writable. It is not the same as the Security & Privacy settings you're looking at.

Share this post


Link to post
13 minutes ago, Flow said:

Just installed Alfred 3, and it works.. :)

 

Alfred 3 uses different directories, and you appear to have incorrect permissions on your Alfred 4 directories.

Share this post


Link to post

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...