Do I have to do it manually? Or there are some ways? Thank you.
If you are in a hurry or it's possible that the data content needs edits you can copy and paste from Excel.
If there's no decorative borders in Excel you'll get a simple result. It has only the cell content and a clipping mask.
Release the clipping mask and you have a group which contains the outline rectangle (=previous clipping mask) and text objects. The rectangle can be used to place the artistically wanted grid.
If you insert borders or fills in Excel prepare to get complex grid. There's probably much more complex clipping masks, groups, colored rectangles and multiple lines than you expect. And the newer Excel you have the more complex it becomes. But if it happens to be visually ok as is and you accept RGB colors, let it be.
I have still alive a version of Excel 2003 because it makes relatively simple graph and table structures if pasted to Illustrator.
At least my legacy Illustrator refuses to place Excel files. That can be otherwise if you have modern versions of Excel and Illustrator. I can only copy and paste directly or Place a printed PDF.
In the web there seems to be much demand how to use Excel data in Illustrator. Search for it. There's even scripts which help to take certain fields from an Excel file and from what's linked to it. Check this for a start: https://www.youtube.com/watch?v=50WQPxTlVL0
Illustrator is not made for this:
- Use InDesign
- center 100 pages of table cells with a few clicks
- sleep more :)
Use Illustrator for logos, icons, and one-off shapes with little, to no text on the artwork. More than half a page of text (and yes, especially tabular data), you should be looking at InDesign without blinking.
Select your rectangular grid and go Pathfinder> Divide. Then Object> Ungroup. This will create individual rectangles and you can then use the Align Panel to center each number. It is important to select the individual rectangle as "Key Object" so alignment happens relative to the rectangle and the rectangle does not move. You can also just center each number at the left and right ends of your "grid" and then use distribute in the align panel to add the center numbers.
Note- You may want to copy your rectangular grid and then hide it's visibility in the layers panel (or just lock it)- this way you have something to go back to in case your rectangles get moved.
Also, to get things centered better optically, you can outline your text (Type> Create Outlines). This will take the type's bounding box (ascenders, descenders, etc.) out of the centering- it will not be editable text afterwards. This will also require that you make a single Compound Path for the numbers that have 2 characters after outlining so they align as one unit and not 2 separate characters.