For those of you getting the office file validation issue, follow these steps Close any Excel window (If open): Click Start, click Run, type regedit, and then click OK. Locate the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0 or 12.0 or 14.0 Select Excel, Select Security, Select FileValidation, point to New on the Edit menu, and then click DWORD (32-bit) Value. Type EnableOnLoad (With no spaces), and then press ENTER. That fixed it for me. Got it from superuser.com/questions/375345/how-to-disable-irritating-office-file-validation-security-alert
On each new line you can add an \hline command which will print a horizontal line in that location. Otherwise, if you draw a basic border in excel the software will typically automatically add that into your code.
I think this is excellent but I do have an issue. My table is too wide for my document, how do I fix this? As I write I am thinking I will narrow one of the the cells in Excel and see if that works.
Need help. When I started the mentioned apps I found "The Office File Validation feature has blocked this file from opening as it may contain harmful content" this. I cant run it. Can you help me in this case? I am using MS office 10 and windows10. Please give me a solution if possible.
when I try to write "subcaption" package I am getting error like "! LaTeX Error: File `caption.sty' not found.Type X to quit or to proceed,or enter new name. (Default extension: sty)Enter file name:! Emergency stop.".Please help me so that I can use "subfigure" environment
hiii I'm doing the same way it is explained...but I'm getting an error...what kind of package I should use for this excel2LaTex...can anyone suggest me please
it looks like it added the add-on, but when I click on convert to Latex, it says "Office detected a problem with this file. Do not open this file to help protect your computer."
my dude. Youre a legend. You should run for president.
ha ha ha .. best comment so far
Thanks, you saved me a lot of time for the redaction of my Bachelor thesis.
this saved my life
Thank you very much. Ive spend all night with this topic
You're a life saver Man! Merci Beaucoup
This saved me hours of agony. Thank you so much for posting this!!
OMG!!! thank you very much for this ❤
you save me a lot of time. thankyou sir
thank you soooooooooooo much you saved my life
Thaaaanks a lot!!! You saved me! 💖
Easily understandable and helped a lot
Thanks a lot :D that's very helpful.. I had to change the commands for the horizontal lines manually but other than that it worked fine!
Thank you very much it saves a lot of my time and energy.....
very nice. A question, how do you manage when the table doesn't fit to one page but need two pages ?
As others have said it, thanks a heap man!
You're welcome! Glad to hear that this dumb little video I made a few years ago is still helping people!
For those of you getting the office file validation issue, follow these steps
Close any Excel window (If open):
Click Start, click Run, type regedit, and then click OK.
Locate the following registry key: HKEY_CURRENT_USER\Software\Microsoft\Office\11.0 or 12.0 or 14.0
Select Excel, Select Security,
Select FileValidation, point to New on the Edit menu, and then click DWORD (32-bit) Value. Type EnableOnLoad (With no spaces), and then press ENTER.
That fixed it for me. Got it from superuser.com/questions/375345/how-to-disable-irritating-office-file-validation-security-alert
thank you so much. this really helped me.
You are the Man!
Thanksssssss!!!!!
Thank you so much!
Really helpful. Thank you!
thank you very much really appreciate your help
Thank You so much
Thank you so much but is it possible to do the same thing from word?
Very Very Interesting.
Thanks a lot for the post!
So, in doing this, how can we add horizontal lines? any easy way to that? thanks. @a HeadForFigures
On each new line you can add an \hline command which will print a horizontal line in that location. Otherwise, if you draw a basic border in excel the software will typically automatically add that into your code.
Great, what a handy! Thanks a lot. :)
I am able to download the Excel2LateX.xla but when I open it, i get a blank excel document, nothing to enable add-in. what could be the problem?
I think this is excellent but I do have an issue. My table is too wide for my document, how do I fix this? As I write I am thinking I will narrow one of the the cells in Excel and see if that works.
my life has changed
Hopefully for the better!
Hopefully for the better!
Please the width of my table doesn’t fit into the page. It has 23 columns. How do I adjust to make it fit into a single page?
Thank you
The coverted file is not copying to clipboard
Same hear, did you find a solution?
there is an error showing ....Undefined Control sequence...\multirow.....Plz help
For some reason it cannot work for a colored table. Any reason why?
Need help. When I started the mentioned apps I found "The Office File Validation feature has blocked this file from opening as it may contain harmful content" this. I cant run it. Can you help me in this case? I am using MS office 10 and windows10. Please give me a solution if possible.
Check my comment above for the solution! :-)
when I try to write "subcaption" package I am getting error like "! LaTeX Error: File `caption.sty' not found.Type X to quit or to proceed,or enter new name. (Default extension: sty)Enter file name:! Emergency stop.".Please help me so that I can use "subfigure" environment
It shows me an error due to the first line where there are color and scale stuff! I guess there is some package l need to add! HELP PLEASE!!
hiii I'm doing the same way it is explained...but I'm getting an error...what kind of package I should use for this excel2LaTex...can anyone suggest me please
If you're getting the Office file Validation error, check the solution above that I provided. Worked for me!
Hey, I am having trouble with Excel 2019, the addin is installed but it doesn't show up anywhere in the ribbons... Does anyone know how to fix that?
restart excel or try opening the addin a couple of times until you find it on excel
Doesnt include formatting if you are using Office 365
i am getting an error like this "Undefined control sequence. \toprule"
you'll have include packages for those commands - you can find them in google.
HELP
my Excel 2010 is blocking the file saying that is not safe , and it doesnt open it ! what can I do to open it?
it looks like it added the add-on, but when I click on convert to Latex, it says "Office detected a problem with this file. Do not open this file to help protect your computer."
Why does it not copy to clipboard??
There is nothing happened when I was click on download.