Working with the Excel tables.
Info * We Work with Prices (Torras)
Problems 2 pieces - we get the preys with a different layout of columns( it is solved ) and the "chip" problem is NOT solved
Chapes are different and take it 0 lines, 5 lines, for example, the name of the campaign logo, etc.
And then we go the necessary line Here is her task - to find the program itself.
This is done manually in the graphic window.
The program has already made us which looks at the name in the first line and then in each column there are "Name of columns" and will compare with the tags that we have set in the fault
It already works.
We need the program.
The task -
1) Find the line that is needed
2) Remove all unnecessary lines before the names of the headlines (photo, price, volume, etc.... )
- - -
Examples of work
*action - download the Ex file (price) in the folder - launch of the program
- the program takes the lines to fit the tags we assigned (the tags are already implemented)
When we find the line, we remove it and press “OK!”The program removes all lines above the line name.
–----–
Screenshot 1 example of Price - we see that our line that needs to start with 5 lines and all above needs to be removed
Screenshot 2 The program itself that selects the tables and after "OK!"They transfer places.
The left part - the tags we put
Central - We get the lines from the Excel file (if they are in the wrong order then they will be in the places)
The right side - Upper hand-down\ lift on the lines ( here we need automation ) + on the "GO " completion process ( here we need removal of all lines above the lines with names)
-
1101 63 0 2 Good day .
The exl is formed again, but in the right format?
In general, you need to see the code, but if you’re already looking for a headline to recognize the tags (and to move the columns), then I don’t have to do anything difficult, just remove all the lines to this line. and the
Go back, let us talk.
-
Понятное дело, что у вас своя кухня и вы варитесь в своем соку, но со стороны смотрю и ,извините, все таки возникает вопрос: "а зачем такой огород городить с с интерфейсами?". Ведь для распознавания и перестановки столбцов достаточно текстового файла с записанными построчно возможными эквивалентами столбцов вашего прайса. Надо будет, дополняйте сколько хотите.
К вам падает файл (в какие то папк(и/у). Пусть программа:
- смотрит постоянно эти папки и при появлении там файла открывает его,
- находит строку с заголовками столбцов ,
- переставляет их на нужные места,
- перемещает в папку выдачи куда надо, и/или включает софт дальнейшей обработке,
- аккуратненько записывает все это в журнал,
- "стоит, кричит, зовет господина и/или строчит кляузу в журнал ошибок" только в том случае если:
- файл не удалось открыть,
- не шмогла найти строку с заголовками столбцов ,
- попался не знакомый столбец.
Все. Оператор посмотрел журналы, Если все хорошо пошел на (обед). Иначе, принял меры и опять пошел.
-
Current freelance projects in the category Web Programming
Update of the one-page website for construction services
22 USD
Updating the existing one-page self-written website for construction services Task: -Redesign of the website -Adding service categories by creating a multi-landing page for 6 categories -Adding photos and descriptions of work to each category -Optimization of the website's… Web Programming ∙ 47 minutes back ∙ 26 proposals |
Development of a website on OpenCart or OcStore (layout/programming)
334 USD
I am considering proposals for both layout separately and full Fullstack work TECHNICAL TASK FOR DEVELOPING AN ONLINE STORE1. General InformationNiche: [Electronics of records and sound]CMS: OcStore 3.0 (mainly for the Ukrainian market, as it has better basic localization) or… HTML & CSS, Web Programming ∙ 1 hour 19 minutes back ∙ 28 proposals |
Refinement of the Front-end e-commerce site on OpencartNeed to refine the front-end of an e-commerce site on OpenCart. Main tasks: fix visual bugs, ensure responsiveness for mobile devices, improve the display of product cards, categories, cart, and checkout page. Neat layout is expected, maintaining the current design, and correct… Content Management Systems, Web Programming ∙ 2 hours 36 minutes back ∙ 29 proposals |
Development of a lead collection form before program upload (MODX)Website: bricscad-ukraine.com.uaCMS: MODXGoal: Create a lead collection mechanism before downloading software for 3 versions: Windows, MacOS, Linux from the site for further processing by the sales department. Web Programming ∙ 6 hours 5 minutes back ∙ 26 proposals |
Remove viruses from the site and update plugins (Wordpress)Need a WordPress specialist for technical refinement of the website Task: Clean the website https://www.mast-agency.com/ from viruses/malicious code, files; (there is a virus on the site that creates pages and redirects to someone else's store) Update plugins so that the… Content Management Systems, Web Programming ∙ 9 hours 37 minutes back ∙ 66 proposals |