script is very helpful, thank You! It is still hard to believe people at Adobe do not think that people in the world use Indesign for making common things, like banners for example. And when you receive media plan with 20+ items and You must name them correctly like 950x250 or 300x600, how to do it easily in Indesign? There's no simple way, like Illustrator Artboards behavior. But now we have a client with many huge print media files, and Illustrator hardly performs. So Indesign is the tool. But at the end comes the naming process for printing house. Huge thank You for very helpful job!
Sorry again to disturb. I used CSv as you said . How should I explain you in detail is there any platform. I am uskin data merge but each time click and update is still taking time and it is not getting enter marks in CSV. I did explore as you said we can seperate headers . There should be any other alternative where we can bring data to InDesign from Excel.
Data merge is the only way I know to import data from Excel. This page has everything you need to know: helpx.adobe.com/indesign/using/data-merge.html You can also ask questions on the Adobe community. Many users will respond with help. Free to join: community.adobe.com/
@@wc7 main(); function main() { var doc = app.activeDocument; var fileExcel = new File("~/Desktop/Test.xlsx"); if (fileExcel.exists) { var ranges = [ "a1:b1", "c1:c3" ]; for (var i = 0; i < ranges.length; i++) { app.excelImportPreferences.rangeName = ranges[i]; doc.pages[0].textFrames[i].place(fileExcel); } } }. I got this script sir Not sure will this work. Do you have video for this.
Why there is no video in TH-cam that how will you insert Excel different cell values into InDesign. Can you please suggest me where can i find that or if you have anything like that
@@smhameed1918 Only way I know to get information from Excel into InDesign is with a CSV file. Like Data Merge uses. Not sure what you are asking exactly. If you want to know how to parse a CSV file in ExtendScript, watch this video: th-cam.com/video/pBZeadMpUoY/w-d-xo.html If that's not it, then I'm not sure what to tell you.
Hi William! It was so incredible to find this video. I've never written script before but started to do a deep dive on your script writing video series to customize this video for my needs. But unfortunately I'm not going to have the time to learn all of that this week before my deadline. But I am excited to in the future! In this video you write a script To insert pages as specific sizes defined in a csv. I am having a solo museum show and I have a database of art I have built in excel and I am laying out a scale model of those artworks in indesign. I need a script that automates the process I am manually doing for 600 rows in a csv. Wondering if you could help?! The script needs to look at the csv and make a new text frame in indesign with the specific width (Column 1) height (column 2) and then insert the image (column 3). I use the datam merge feature daily in indesign and the column header for the image column has an @ symbol which tells indesign it is an image. All of my images are in a single folder and when I save the csv that I am running the datamerge from in the same folder as the images there is no need to tell it where those images are located. Any help would be appreciated! I am sure you are busy so if you don't have time to help I understand. Keep up the good work!
Another idea would be that I could run a datamerge on all of the images so that they are already in an indesign document. Then each of image names would be listed in the links panel. Then a script could be written to look at the three columns in the csv and to look for the file name listed in the links panel and to change the text frame to the corresponding size in the csv. That would eliminate having to insert content.
So the script would say: Go to the document called MUSEUM. Change every image's text frame in the document to the corresponding values in the csv. In the csv column 1 = width, column 2 = height, column 3 = file name of image. :)
script is very helpful, thank You! It is still hard to believe people at Adobe do not think that people in the world use Indesign for making common things, like banners for example. And when you receive media plan with 20+ items and You must name them correctly like 950x250 or 300x600, how to do it easily in Indesign? There's no simple way, like Illustrator Artboards behavior. But now we have a client with many huge print media files, and Illustrator hardly performs. So Indesign is the tool. But at the end comes the naming process for printing house. Huge thank You for very helpful job!
Sorry again to disturb. I used CSv as you said . How should I explain you in detail is there any platform. I am uskin data merge but each time click and update is still taking time and it is not getting enter marks in CSV. I did explore as you said we can seperate headers . There should be any other alternative where we can bring data to InDesign from Excel.
Data merge is the only way I know to import data from Excel. This page has everything you need to know:
helpx.adobe.com/indesign/using/data-merge.html
You can also ask questions on the Adobe community. Many users will respond with help. Free to join:
community.adobe.com/
@@wc7 thank you sir. You don't know how you helped me growing my career. Thank you for your support.
@@wc7 main(); function main() { var doc = app.activeDocument; var fileExcel = new File("~/Desktop/Test.xlsx"); if (fileExcel.exists) { var ranges = [ "a1:b1", "c1:c3" ]; for (var i = 0; i < ranges.length; i++) { app.excelImportPreferences.rangeName = ranges[i]; doc.pages[0].textFrames[i].place(fileExcel); } } }. I got this script sir
Not sure will this work. Do you have video for this.
Why there is no video in TH-cam that how will you insert Excel different cell values into InDesign. Can you please suggest me where can i find that or if you have anything like that
There are many videos about the topic. Search TH-cam for "indesign data merge".
@@wc7 not data merge. Script video. There is no such video. From Excel to InDesign different cell reference need to be inserted in InDesign
@@smhameed1918 Only way I know to get information from Excel into InDesign is with a CSV file. Like Data Merge uses. Not sure what you are asking exactly. If you want to know how to parse a CSV file in ExtendScript, watch this video: th-cam.com/video/pBZeadMpUoY/w-d-xo.html
If that's not it, then I'm not sure what to tell you.
Hi William! It was so incredible to find this video. I've never written script before but started to do a deep dive on your script writing video series to customize this video for my needs. But unfortunately I'm not going to have the time to learn all of that this week before my deadline. But I am excited to in the future! In this video you write a script To insert pages as specific sizes defined in a csv. I am having a solo museum show and I have a database of art I have built in excel and I am laying out a scale model of those artworks in indesign. I need a script that automates the process I am manually doing for 600 rows in a csv. Wondering if you could help?! The script needs to look at the csv and make a new text frame in indesign with the specific width (Column 1) height (column 2) and then insert the image (column 3). I use the datam merge feature daily in indesign and the column header for the image column has an @ symbol which tells indesign it is an image. All of my images are in a single folder and when I save the csv that I am running the datamerge from in the same folder as the images there is no need to tell it where those images are located. Any help would be appreciated! I am sure you are busy so if you don't have time to help I understand. Keep up the good work!
Another idea would be that I could run a datamerge on all of the images so that they are already in an indesign document. Then each of image names would be listed in the links panel. Then a script could be written to look at the three columns in the csv and to look for the file name listed in the links panel and to change the text frame to the corresponding size in the csv. That would eliminate having to insert content.
So the script would say: Go to the document called MUSEUM. Change every image's text frame in the document to the corresponding values in the csv. In the csv column 1 = width, column 2 = height, column 3 = file name of image. :)