Пікірлер

• 
  @kiptooj15 күн бұрын

  thanks for the video. I had started following a long route like learning python codes to achieve this

• 
  @JakeLesser20 күн бұрын

  Thanks, very helpful.

• 
  @Adam-ei5itАй бұрын

  I refreshed and I get a weird message : initialization of the sata source failed. it doesn't say if I can ot can not import PDF. Any clue ?

• 
  @nayansaha4349Ай бұрын

  Thanks a lot. I am so grateful to you. You are so genius. God bless you !

• 
  @joycechong613Ай бұрын

  You're most welcome!

• 
  @MrMandarpriya2 ай бұрын

  just doesn't work in mac m1. It is like making a joke

• 
  @hoachongxian57282 ай бұрын

  Thank you for doing such a good guide

• 
  @joycechong6132 ай бұрын

  You're most welcome! 😀

• 
  @miroslavdusko8492 ай бұрын

  Thanks for video. I have one question. Can you explain why one time I see the option import data "From PDF" and after few minutes this option is missing?

• 
  @joycechong6132 ай бұрын

  This seems odd. The option should be there all along. Which version of excel you are using?

• 
  @mrashid2292 ай бұрын

  So grateful to you friend, very clearly explained the steps, you saved my time and effort. Just subscribed you to learn more.

• 
  @joycechong6132 ай бұрын

  Thank you! It's so nice to hear this from you. :)

• 
  @piplol98112 ай бұрын

  How to send email to multiple people?

• 
  @hugoprado5062 ай бұрын

  Would you sell your Instagram username?

• 
  @BebomiMia2 ай бұрын

  On step 2 it showing Datasource.Error this device is not ready?

• 
  @joycechong6132 ай бұрын

  community.fabric.microsoft.com/t5/Desktop/DataSource-Error-Could-not-find-a-part-of-the-path/td-p/2569932

• 
  @joycechong6132 ай бұрын

  You can try this. I believe it's something to do with perhaps you did change the file location before.

• 
  @CatherineKatka2 ай бұрын

  Thank you, this is a great help, IT WORKS !!!

• 
  @joycechong6132 ай бұрын

  Thanks! 😊

• 
  @vkgupta41073 ай бұрын

  not clear

• 
  @joycechong6132 ай бұрын

  What is the issue that you're having then?

• 
  @sergiosergio75563 ай бұрын

  Thank You very much!

• 
  @joycechong6133 ай бұрын

  Welcome!

• 
  @oliverfletcher79293 ай бұрын

  You’re a genius!!

• 
  @joycechong6133 ай бұрын

  You're most welcome! Glad it's helping you.

• 
  @ceyhunozdemir60573 ай бұрын

  links dead

• 
  @joycechong6133 ай бұрын

  Hi, I am able to open the forum and document links from my end. Let me know which link is not working thanks!

• 
  @ceyhunozdemir60573 ай бұрын

  @@joycechong613 they both look dead. Maybe because of the shortcuts or the ISP

• 
  @joycechong6133 ай бұрын

  Hi thanks for letting me know, I just updated the original link in the description section. Thanks!

• 
  @user-cb6mo4xr3b4 ай бұрын

  Thank you very much

• 
  @joycechong6134 ай бұрын

  You're most welcome! 😁

• 
  @wasimqadari20774 ай бұрын

  While Trying this formula I am facing this error➡ Expression error: The name 'Pdf.Tables' wasn't recognized. Make sure it's spelled correctly.

• 
  @joycechong6134 ай бұрын

  You may check if any spelling is not correct and make changes accordingly. I believe it is related to the spelling of your words.

• 
  @sachingeorge8793 ай бұрын

  Its right!! I am working as a partime worker on santa monics i have faced this problem,,, so wiered

• 
  @wasimqadari20773 ай бұрын

  @@joycechong613There was not any spelling mistake, I copied the formula from your post.

• 
  @joycechong6133 ай бұрын

  @@wasimqadari2077 Ok! Checking with you, if you're using your own file, did you change this xxx to your document path? = Pdf.Tables(File.Contents("xxx"), [Implementation="1.3"])

• 
  @wasimqadari20773 ай бұрын

  @@joycechong613 Of course sir

• 
  @user-fo7rs4iy6m4 ай бұрын

  I cant enter the forum. Is it no longer available?

• 
  @joycechong6134 ай бұрын

  Hi, the forum link is still working on my end. You can try this as well! answers.microsoft.com/en-us/msoffice/forum/all/power-query-get-transform-get-data-from-pdf/1bd2afdc-2912-4b08-aae6-40250b0d589d

• 
  @winaykumar_m4 ай бұрын

  Hi, how to apply a rule to import all tables in the pdf having a similar data structure? Ensuring that the entire data is captured

• 
  @joycechong6134 ай бұрын

  When you load the PDF, you should see a list of all the tables inside your pdf. From there, you can select multiple tables you want to load. In this way, you can import all the tables in your pdf.

• 
  @winaykumar_m4 ай бұрын

  @@joycechong613 Thanks did figure this out. Tried doing multi select and then appended similar tables to create the consolidated data. Please LMK if there's faster way of doing the same?

• 
  @sonalpatil26194 ай бұрын

  Hey thanks alot its awesome it helped al lot 🎉

• 
  @karthickradhakrishnan98215 ай бұрын

  cant download your excel documents from shorten url

• 
  @joycechong6135 ай бұрын

  Hi thanks for letting me know! Kindly try this link instead: drive.google.com/drive/folders/17oQM_Kx9ZSYZdY6tapAS6lgNEKRTbnED

• 
  @karanpatil82185 ай бұрын

  Thank you 🙏

• 
  @joycechong6135 ай бұрын

  Welcome!

• 
  @1Gollywalk6 ай бұрын

  From pdf not showing in my Excel (MS Office 2019 Plus) and I want to "import" multiple pdf files. Can you help please. I am aware of the single file workaround with "= Pdf.Tables(File.Contents....", but is is only for a single file. Is there away to add multiple files?

• 
  @stevenlitvintchouk31316 ай бұрын

  Does not work for me. When I select Data\Get Data\From Other Sources\Blank Query, Excel freezes ("Not Responding") and it never opens the Power Query Editor.

• 
  @elle13nako6 ай бұрын

  Hi, the steps are very clear but it doesn't work for me. After i pasted the formula, no table generate. I tried to change 1.0 / 1.2 as well, it just didn't run. I am using Office 365 :(

• 
  @joycechong6136 ай бұрын

  How about value 1.1 / 1.3 ? Give them a try.

• 
  @elle13nako6 ай бұрын

  Hi, thanks for replying. Actually, I tried all. Does it work for fillable PDF form? Because mine PDF was an application form.

• 
  @bpavan14196 ай бұрын

  how to get that document which is shown at 3:06

• 
  @joycechong6136 ай бұрын

  You can use your own document haha! Any document can be imported using this method.

• 
  @mohammadshameer43026 ай бұрын

  NOT WORKING

• 
  @joycechong6136 ай бұрын

  Which part?

• 
  @ooomyoom6 ай бұрын

  my table is showing empty , please help

• 
  @joycechong6136 ай бұрын

  Have you checked your document yet? See if you select the correct document or not.

• 
  @ooomyoom6 ай бұрын

  The document is correct @@joycechong613

• 
  @gowthamdharmaraj99797 ай бұрын

  thank you 😊

• 
  @joycechong6137 ай бұрын

  Welcome!

• 
  @user-xq4uz9er7p8 ай бұрын

  it shows my table is empty

• 
  @FakeStreamer8 ай бұрын

  I followed ervery step of the way. When I enable the zoom it just zooms in and does nothing. When I press the hotkey again it zooms in even further and still does nothing.

• 
  @Noizeproxy9 ай бұрын

  I'm trying to figure out what I'm doing to creat this issue, but I followed your steps, and it works. But if I close out of OBS, then reopen, it stops working. I tried doing the steps from the beginning again, and it works. When I reopen, and it doesn't work, I checked the log, and it shows that "Zoom=true" or "Zoom=false" when I use the hotkey, but nothing is happening on screen. Very confused.

• 
  @kmr55349 ай бұрын

  how to import multiple pdf files into excel

• 
  @joycechong6139 ай бұрын

  Can you combine all your separate pdf files into one? Then you can proceed to use the same method using the combined pdf file.

• 
  @kmr55349 ай бұрын

  @@joycechong613 unable to load all pages content .at a time only one page content is loading.

• 
  @HertWasHere10 ай бұрын

  This is the video the creator of the script should've made!

• 
  @joycechong6139 ай бұрын

  Yea the creator of the script helped us a lot here!

• 
  @user-re1rx6tf3p10 ай бұрын

  You showed us how to import one page. I have a PDF that is a big table that spans 13 pages. How would I import all 13 pages of the big table? Please let me know ASAP

• 
  @joycechong6139 ай бұрын

  Hey you should be able to import all 13 pages using the same method. You should be able to see all the displays of the 13 tables of your document after you finish the steps @4:15. You can select whatever page you want to load from there. Hope this helps!

• 
  @morhenwolf634110 ай бұрын

  Doesn't work. I get this error. I redid the steps multiple times, no success. [zoom_and_follow_mouse.py] Traceback (most recent call last): [zoom_and_follow_mouse.py] File "C:\OBS Files/MorhenWolf/Local Files/Effects/Mouse Follow\zoom_and_follow_mouse.py", line 7, in <module> [zoom_and_follow_mouse.py] import pymonctl as pmc [zoom_and_follow_mouse.py] ModuleNotFoundError: No module named 'pymonctl'

• 
  @yasinberkay8 ай бұрын

  try running OBS as administrator

• 
  @morhenwolf63418 ай бұрын

  @@yasinberkay I already did that

• 
  @ArijamLoves3 ай бұрын

  I have the sam problem, did you manage to resolve it?@@morhenwolf6341

• 
  @user-wm4lj4jx3c10 ай бұрын

  Expression.SyntaxError: Token Eof expected. How to solve error

• 
  @remoteworkstuff10 ай бұрын

  Thank you so much for the video. I also tried to use the same instruction from Microsoft help, but still encountered prob with the formula link given to copy-paste. However.. 3:05 My PDF file doesn't provide "copy as path" on th right click menu, can't also copy paste manually by "pressing Ctrl+Shift+C then Paste/Ctrl+V". Would be great if you could give some help with this issue.

• 
  @joycechong6139 ай бұрын

  Hi how about you try to right click your document. Select Properties > General. Combine these 3 info together: 1. Location 2. Add a slash \ after location 3. Type of file, for example .pdf in this case Example of the document path should be something like this C:\Users\USER\Desktop\documentname.pdf

• 
  @SudhirKay10 ай бұрын

  Hi does this work for excel on mac by any chance?

• 
  @joycechong61310 ай бұрын

  Ah I have no idea honestly. Have you given this a try already?

• 
  @MsMassad11 ай бұрын

  Thank you very much

• 
  @joycechong61310 ай бұрын

  You're most welcome!

• 
  @ghazinspace Жыл бұрын

  you are the best

• 
  @muhammadsafdar692 Жыл бұрын

  Kon sa version Hy ye??? Humary pass open ni horaha hy

• 
  @PadangSMC Жыл бұрын

  Thank You, Only on this channel I got the OBS - Zoom and Follow installation which really works

• 
  @joycechong613 Жыл бұрын

  Welcome! :)

• 
  @AyranLP Жыл бұрын

  Thank you so much, youve saved my study preperations <3

• 
  @joycechong613 Жыл бұрын

  Welcome, all the best in your studies!

• 
  @mwajahat Жыл бұрын

  When press Refresh Button, then get this error, pls help on it, Thanks "Initialization of the data source is failed."

• 
  @joycechong613 Жыл бұрын

  Hi, I have not encountered this problem before, but maybe you can run a repair on your excel? I searched for some resources online and saw this:- itecnote.com/tecnote/initialization-of-the-data-source-failed-excel-2016/

• 
  @enersysthermal8921 Жыл бұрын

  It worked! Thank You! Keep posting more information!

• 
  @joycechong613 Жыл бұрын

  Will do so! I'm happy to be able to help you with this. :)

• 
  @grmnepal Жыл бұрын

  Why I can not find refresh option😔😔

• 
  @joycechong613 Жыл бұрын

  After you download the excel copy, open the excel & make sure you click 'Enable Editing' on Protected View. Then right click on the green row, you will be able to find the refresh option.

• 
  @ronnykp7808 Жыл бұрын

  Hi, I tried, its working. thank you very much.

• 
  @joycechong613 Жыл бұрын

  Hi, welcome! I'm glad this helps you. :)

• 
  @ashish.bonde.84 Жыл бұрын

  Thanks it worked for me but please tell me how do I select all tables (hundred of tables I have) in one go

• 
  @joycechong613 Жыл бұрын

  Hi. I believe Power Query comes in handy for your situation. Try to search 'combine multiple tables using Power Query' in KZread. Hopefully this helps.