Vba code examples for excel web scraping työt
FIN... Excel-tiedosto sisältää satoja rivejä eri tuotteita, joista on esimerkiksi seuraavat tuotetiedot: positio, tuotepyyntö, tuotevaatimus, tuotenimi, tuotenumero, tuotekuvaus, hinta ja kuvakuvalinkki. Näistä tiedoista pitäisi saada atomatisoitua tuotekortteja. Tuotekortti on käytännössä A4-kokoinen PDF-dokumentti, jonka yksi sivu on yhden tuotteen tuotekortti. Mainitsen tässä InDesignin, koska sitä osaan käyttää ja ajattelin, että jos voin määrittää InDesigniin kenttien paikat, niin olisiko mahdollista, että Excel-tiedot tippuisivat jonkin scriptin avulla näihin kenttiin ja ikään kuin visuaalinen ulkoasu pysyisi koko ajan omissa hyppysiss&a...
Hei, Olen tuore asfalttialan yrittäjä (yrityksessä neljä henkilöä) ja tarvitsen seuraavia palveluita: myyntilaskujen luominen työkirjanpidosta (kilometrien laskeminen, eri työkohteiden erittely ja eri työtyyppien erittely). Osaat käyttää sujuvasti exceliä ja muita perustoimisto-ohjelmistoja. Laskut kootaan viikon loppupuolella, kun viikon työt on tehty. Mahdollisesti muuta toimistotyötä tarjolla myöhemmin, jos osaava henkilö löytyy.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies the Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is available and the Project needs to be done using Visual Studio. Azure SQL database management and required SQL queries are not in the scope of the Project.
Excel Add-In that retrieves and uploads table-data from and to Azure SQL database . Add-In also modifies andthe Excel sheets and controls user interaction. For mosts of the sheet mofdification there is available VBA script that need to be traslated to C#-code. Initial Visual Studio 2015 Project code is avaiable and the Project needs to be done using Visual Studio. Azure SQL database and required SQL queries are and database management is not in the scope of the Project.
Excel Add-In joka hakee ja tallentaa taulukkomuodossa olevaa dataa Azure SQL-kannasta/-taan. Lisäksi ohjelmallista Excel muokkausta ja hallintaa C#-koodilla. Osaan Excel muokkauksista valmis VBA-script, joka muutettava C#-kielelle. Visual Studio 2015 alkukoodi, SQL Azure tietokanta ja kyselyt valmiina.
Toimitamme tuotetietokannat excel-tiedostoina, tuotteiden valokuvat ja tuotteiden avainsanat yms. ja ne syötetään csv-tiedoston avulla hakukoneystävällisesti (esim. Woothemes Product CSV Import Suite + Yoast Woocommerce) wordpress-sivustolle, jolle on jo asennettu woocommerce ja jossa on jo tuotteita. Tuotteita tulisi lisää noin 200-400. Woocommercea käytetään Catalogue-modessa, eli sivusto ei ole varsinaisesti automatisoitu verkkokauppa.
2200 kuvausta, excel. referenssitiedosto sekä kuvia ja englanninkielinen käännös käytössä. paljon toistoa. laadukas käännös.
This is my website link I have used "Classima – Classified Ads WordPress Theme" theme. I want to upload date from xls sheet. Excel attached for your reference. Raduus Theme is not providing support and they only provides category and location import options. Can you help me to import data
I'm...seeking a skilled graphic designer to create a modern, edgy design for a black t-shirt. You will be crafting an image of a devil struggling to hold up the world. Critical specifics include: - Style: Picture should radiate a modern, edgy aesthetic rather than lean towards traditional or cartoonish styles. - Devil's Pose: Illustrate the devil struggling to hold up the world, indicating a sense of challenge and burden. - Color Scheme: Use a vibrant color palette to contrast with the black t-shirt, allowing the design to really pop. Ideal candidates should have robust experience in t-shirt graphic design, an innovative flare for edgy/modern designs, and proficiency working with vibrant color schemes. A portfolio with examples of similar work will signific...
...in search of a Social Media Expert who can train me and help me implement a strategic plan to generate leads and sales through social media platforms: Facebook, Instagram, and Twitter. This will be a brand new venture for a well established business. Previously sold face to face. Key Points: - I'm interested in someone with extensive experience in social media marketing and sales, who can help implement a clear plan for increasing lead generation. - The target audience is business owners. I'm open to suggestions on how to best reach them and engage with them. - I'm looking for a trainer, so the ability to explain things in a simple, understandable way is crucial. Excellent English is essential. - Experience working with small businesses or in the B2B...
I'm in need of a talented video editor to help bring my vlogs to life. Each vide...to help bring my vlogs to life. Each video will be around 10-15 minutes long and I'm looking for someone who can match my desired style, which is a good pace and chic/elegant. In terms of video editing specifics, I'm hoping to incorporate cute and feminine transitions to make the videos more engaging. Key Requirements: - Video editing experience, especially in the realm of vlogging content - Able to maintain a good pace and chic/elegant style - Skilled in incorporating cute and feminine transitions The ideal candidate will have a keen eye for detail, a solid understanding of the Youtube vlogging landscape, and be creative in their approach to video editing. Please INCLUDE any...
I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability ...
I need a professional and creative designer to t...presentation. This should be polished with a corporate style, yet engaging and impressive for a business meeting. - Design should be corporate and professional - Animations should be created to enhance the presentation - The work is urgent, turnaround of 5 hours is required. My presentation is for tomorrow 21 may. Ideal freelancer will have: - Proficient in Microsoft PowerPoint with a keen eye for design and layout - Skilled in creating visually appealing presentations with a focus on clarity and engagement - Able to think creatively and implement interactive elements and animations to enhance the presentation Please provide examples of previous PowerPoint presentations you've created, particularly those...
I need a catalog to be designed keeping a classic and elegant aesthetic in focus. This catalog should function as a product showcase for my clothing and apparel line. Key Requirements: - Outstanding design skills, preferably in the fashion industry - Able to deliver a classic yet engaging aesthetic - Experience in catalog layout design. The goal is to create a captivating and beautiful product story that will inspire and engage potential customers. If you have a background in clothing and apparel design, it will be beneficial. Please share examples of similar work while bidding. We are exporting to Europe and other Asian countries.
Description: I am looking for an experienced developer or development team to create a website with an integrated API. The website will serve as an information platform and provide dynamic content from a book. Requirements: Website Development: Design and development of a user-friendly and responsive website. Use of a content management system (CMS) like WordPress or a web framework like Django or Flask. Integration of search functions and navigation elements. API Integration: Development of a RESTful API to provide access to various parts of the book (chapters, pages, paragraphs). API endpoints such as /api/book/{chapter}, /api/book/{page}, etc., to handle requests and return the corresponding data. Database: Setup of a database (e.g., MySQL, PostgreSQL) to store the bo...
I ...Jordan, Syria, Lebanon, Canda, and USA) - You can use pictures on the web of before and after for relative projects to show how it was before and how it became after. - I expect to see Technical terminologies to demonstrate how i went from 36% Inventory Accuracy to an average of 98% using zone picking, barcoded inventory, and mixed wave picking strategies as an example. (You will need to make points like these for every relevant before and after picture. Your work will be crucial in showcasing my capabilities to potential clients and employers. You will start by making a complete template with your idea of how i can best represent myself. If your delivery is impressive i would like to Create a few more "REAL" Project examples together in more in...
I need a flutter developer. The application is ready on github so the deployment on App Store is what's needed for iOS 16. Your primary role will be to ensure successful and smooth application upload and compatibility check. Please have examples of previous similar work to show.
I require a competent professional for the design of an x-ray lead layout. The shielding design will cater to enhancing radiation protection in a chiropractic facility specifically focusing on an x-ray machine. - The shielding design is expected to be proficient for radiation protection, positioning guidance, and overall shielding design. - Must have prior experience in working within a chiropractic or medical facility, focusing on radiation protection. - Must possess knowledge of industry standards concerning X-ray machines. - Previous experience in similar roles dealing with shielding design is a significant benefit. Ideal skills and qualifications include: - Engineering or design background, specifically in lead shielding layouts. - Experience in medical or health ...
I'm looking for a freelancer to help me extract financial data and regulatory filings from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in web scraping...
I'm seeking a skilled web developer to update my current PHP website admin interface to utilize the Bootstrap 4 admin theme. The primary purpose of this admin section is to manage content, so I'm particularly interested in revamping the forms and input fields. Key requirements include: - Update of the existing admin interface to Bootstrap 4 admin theme - Focus on enhancing the forms and input fields - Implementation of data validation within the forms The ideal candidate for this project should have: - Proficient in PHP and Bootstrap - Prior experience in revamping website admin interfaces - Strong understanding of data validation techniques - A good eye for user-friendly design Your task will be to seamlessly integrate the Bootstrap 4 admin theme and ensu...
Rekisteröidy tai kirjaudu sisään nähdäksesi tiedot.
I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.
Description: We are looking for a highly skilled and motivated frontend developer to create a cross-platform desktop application for Windows and MacOS using Electron.js. The application will manage audio, text, and video data, and will utilize websockets for backend data transfer. Key Responsibilities: Develop a responsive and efficient desktop application using , JavaScript, HTML, and CSS. Implement and integrate features to manage audio, text, and video data. Ensure smooth and secure data transfer using websockets. Conduct thorough testing to ensure the application is robust and bug-free. Work closely with stakeholders to gather requirements and iterate based on feedback. Provide comprehensive and clear code documentation. Requirements: Proven experience ...
I need a skilled pro...will primarily serve the purpose of promoting events. I have a few specific features in mind for this site. Customer can book Pooja and other activities online with Payment Gateway. The content on the website will be managed by the admin only. I will be responsible for posting and updating the content. Ideal skills and experience for this project would include: - Proficiency in web development with experience in creating multi-language websites. - A good eye for design to ensure a visually appealing website. - Experience in implementing unique features such as event calendars and streaming services. - Prior experience in religious or community websites would be a plus. Please provide examples of previous websites you ha...
I have a ...plan drafted on which I want to have converted into Excel. The Excel file should mirror the plan in all aspects, including costs, expenses, revenue, and financial projections. Key Requirements: - The Excel file should be a faithful recreation of the original financial plan, ensuring that all details are accurately transferred. - It should include all costs, expenses, revenue figures, and financial projections. - You will need to have experience in financial planning, specifically in converting plans from to Excel. To be clear: I do not need business plan development, I need mostly technical work of converting one form of financial plan to the other (Excel file). Specifics: - I do not need any charts in the Excel file, but the use o...
I need a freelancer with web scraping skills who can extract product prices and models from my 17 competitors. Ideally, the freelancer should be able to: Extract information accurately and comprehensively. Upload all the extracted information into an Excel sheet. Create a simple online website to facilitate this process. I have hosting and a domain. Enable me to update the extracted information with a single click. Complete this task within a maximum of 48 hours. Please include detailed proposals in your application on how you would approach this project.
I'm starting a ...children's clothing store, and I need a Shopify store built to cater for infants (0-2 years), toddlers (2-5 years), and kids (6-12 years). We will be dropshipping, using Printful. Key Project Requirements: - **Design Style**: The store needs to have a playful design. It should be visually engaging and appeal to children and their parents. - **Functionality**: One of the key functionalities I need is a size guide. Ensuring customers can easily make the right size choices for their children is paramount. Ideal Skills: - Experience with Shopify and building e-commerce stores. - A good eye for playful and child-friendly design. - Previous experience with children's clothing stores would be a plus. Please provide examples of any ...
I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-party Google map API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Jav...
...am looking for a developer who can create an Android mobile optical reader application using OpenCV for image filtering. The main purpose of the application is to apply image filtering effects to the captured images. I would like to have an application made that will read the rectangular optical form with 25 questions and 5 options specified in the appendix, with a phone camera. Through the application, first the user will enter the answer key of the exam, then the correct/wrong/blank questions should be calculated by determining the options marked with the appropriate image processing algorithm. In addition, the number of times each question was marked as correct, how many times as incorrect and blank should be kept during each determination. The application must be deve...
I'm looking for a creative and skilled logo designer to help me create a logo for my online toy shop, Discovery Play Palace. The ideal logo will be: - Colorful and vibrant to appeal to children - Simple and easy to recognize - Reflect the educational and learning theme of my shop - Available in all required formats for various applications Please consider the following in your design: - It should encompass toy animals, which are the primary products in my store - The name 'Discovery Play Palace' should be clearly integrated - The design needs to be versatile and scalable I'm looking for a creative individual who has experience in creating child-friendly designs and logos for educational purposes. Your portfolio should include ex...
I have a data in my excel sheet. They are from column A - J, 10 column, 4137 rows of data. The data are in mixed string format, which means all long text mentioning about their company. I need to do some data analysis. So i need help in doing NLP for those data to clean and filter the data. I need help in doing NLP for the data and provide me the python code use to do the analysis, I will need like the summaries of the text. For example, for column Funder Purpose the row contain info like "Since the business started, we have been fully relying on our internal fund. We plan to utilize this fund to support our working capital requirement and operating expenses. Based on our business growth progress, we are confident in our repayment capacity....
I am in need of a unique logo that combines both text and imagery for "Kurtis Garage". It should be eye-catching and make a strong impact. - The Logo: Take a creative approach and feel free to incorporate relevant elements into the design. Unfortunately, I haven't specified the particular symbol to be used, so I am open to suggestions. It could be anything resonating with a garage theme. - Colors: I prefer red, black, and white. However, I am open to other innovative color concepts that would enhance the overall design and meets the aesthetics I envision for my brand. - Ideal Candidate: Someone with a strong background in graphic design and logo creation. Prior experience designing logos related to garages, cars or tools would be advantageous. An ability to...
I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in column A of the VAT output f...
I'm in need of a professional with expertise in WhatsApp and Facebook development. I require the implementation of various features in these platforms, including but not limited to: - Chatbot integration - Group messaging functionality - User authentication and security I'm open to additional sugges...in these platforms, including but not limited to: - Chatbot integration - Group messaging functionality - User authentication and security I'm open to additional suggestions or features that could enhance the usability and user experience of these social media platforms. Successful candidates should have a strong portfolio with examples of past work in similar projects. Please include this in your application. Please note that there is no strict deadline for...
I need a clean, professional Wordpress website created for my brand. It must be simplistic, user-friendly, and designed to cater to B2B customers. The primary purpose of this website is to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B w...
...a seasoned logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature past examples of iconic logo design and demonstrate how you'v...
I am looking for freelancers with persuasive sales skills and familiarity with the digital marketplace. Your mission, should you choose to accept it, will be to sell a wide variety of '.com' internet domain names - approximately 150 in total. Here's what you'll need to do: - Present domain names to potential buyers * Examples: , , - Be able to familiarize yourself with the full list of domain names when making sales. Key Notes: - This is a commission-based role, and I intend to reward successful sales generously. - No website design or layout is required as the sale is purely for the domain names. - There are no specific keywords or phrases related to the domain names as they cover an extensive range of subjects. Ideal Candidate:
...loading issue. - Implement effective speed optimization strategies for my Divi WordPress site to improve the editing and updating experience. - Ensure the site remains visually appealing and fully functional post-optimization. - I'd also appreciate any advice on maintaining optimal loading speeds in the future. Ideal Skills and Experience: - Extensive experience with Divi WordPress sites and the Divi theme. - Proven track record in speed optimization, particularly on shared hosting environments. - Ability to troubleshoot and resolve issues efficiently to minimize downtime. - Strong communication skills and a collaborative approach, as I'm keen to understand the process and maintain some level of involvement. Please provide examples of similar projects you'...
I'm in need of a professional who can convert a Word document into a visually compelling PowerPoint presentation. The presentation should be designed with clients and the general public in mind, so it needs...of graphics and charts to represent data and key points - Implementation of interactive elements and animations to make the presentation dynamic and engaging Ideal Skills and Experience: - Proficient in Microsoft PowerPoint with a keen eye for design and layout - Skilled in creating visually appealing presentations with a focus on clarity and engagement - Able to think creatively and implement interactive elements and animations to enhance the presentation Please provide examples of previous PowerPoint presentations you've created, particularly those for...
I'm looking to buy a complete and *READY* code for a football management browser game (like Hattrick, Trophy Manager, etc.). Essential features include: - Registration - Team creation and player management - Tactics creation - Transfers - Game simulation - Leagues system. Preferred technologies are JavaScript and C#, but others are acceptable. I'm also open to offers for partially finished games.
I'm in need of a unique and innovative logo to boost brand recognition. The design shou...be memorable, easily recognizable and stand out from the competition. While I'm open to all styles, I'm particularly interested in seeing fresh and out-of-the-box ideas that can make my brand truly distinctive. Ideal skills and experience for this job: - Strong portfolio with a track record of creating innovative and creative logos - Proficiency in graphic design software - Ability to understand and execute brand recognition principles - Understanding of various styles and trends in the logo design industry Please submit your portfolio and provide examples of innovative work you've done in the past. Your bid should also include details on your approach to creating a...
I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed
I'm in...proficient Python developer who can help compile a Python code, that I have acquired from GitHub, into an executable format for Windows. As the client, I expect: - Understanding the existing Python code and its dependencies - Transforming the Python code into a Windows executable file Successful freelancers should provide a detailed project proposal illustrating how they plan to compile the code to exe on a Windows operating system. Though no specific Python libraries or frameworks were mentioned, a background in Python coding and debugging is paramount. The ideal freelancer should have a deep understanding of Python code, dependencies, and experience dealing with code from GitHub. Experience in generating Windows executabl...
...python3 programmer to create a sensor-data generator for the website www.voeazul.com.br. The objective is to send a POST request to the site with valid sensor-data in order to obtain a particular cookie (_abck) for data analysis purposes. The sensor data to be simulated includes mouse movements, keyboard interactions, and browser interactions. Key Requirements: - Create a sensor-data generator in Java or python3 - The generator should simulate mouse movements, keyboard interactions, and browser interactions - The sensor-data should be valid enough to trigger the generation of the _abck cookie upon sending a POST request to Ideal Skills and Experience: - Proficiency in Java/python3 programming - Experience in web scraping and automation - Knowledge of coo...
I'm looking for a skilled advertising professional who can help me increase brand awareness through social media. Key Requirements: - Develop a comprehensive brand awareness campaign on Facebook, Instagram and Twitter. - Create engaging and relevant content that resonates with our target audience. - Utilize best practices in social media marketing to enhance campaign effectiveness. Ideal Skills: - Proven experience in social media marketing and brand awareness campaigns. - Strong understanding of Facebook, Instagram, and Twitter advertising. - Creative and strategic thinker with a clear understanding of the target audience. - Excellent communication and interpersonal skills. - Results-driven approach to advertising. Please provide examples of previous work and a st...
I am in need of a talented and experienced logo designer to craft a modern logo for my brand. The logo should be modern, sleek, yet eye-catching and memorable. Key points: - Design a modern logo: The primary goal of this project is to create a logo that is distinctly modern in style. The logo should be clean and minimalistic, yet able to attract attention and convey the essence of my brand. - Evidence of experience: I would like to see evidence of your prior experience in modern logo design. Please provide examples of previous work that you believe showcase your ability to create a modern, sophisticated logo. - Understanding of branding: A good grasp of branding principles and an ability to interpret a brand's identity into a visual design is highly desirable. Ideal sk...
